Recurring Monthly Amounts

[dcecil]

I know this sounds simple, but I'm getting beat up on it. : [color:green]I am creating a "Bill Payment" database and I have a field called "Monthly?". It is based on a Yes/No Value List. I need a calculation that if the answer is Yes, it will take the entered "Due Date" and add 1 month to that and place it in the field called "Next Due Date".

Thanks,

[mr_vodka]

Case ( Monthly = "Yes"; Date ( Month (Due Date) +1; Day (Due Date); Year (Due Date) ) )

[dcecil]

Wow, that was quick! It works great. Thanks so much. :