I'm having a formulating dilemma that I hope anyone can help with. I need to do some reporting for a list of people so I can know there anniversary dates for charging them. However the way it works isn't just on fixed number of days. its always the next month on the same day of your intial date.

For Example:

If you became a customer on 1/2/07, your annivesary date would be 2/2/07, which is 31 days.

But if you became a customer on 2/2/07, your anniversary date would be 3/2/07, whichh is 30 days.

Since not every month has the same numbers of days, I'm stumped.

How would I construct the formula so I could pull a list each day of who has hit their annivesary date. I can't seem to get a date diff formula that makes it happen.

Can anyone help with this? It would be much appreciated.

Anniversary date = DateSerial(Year(StartDate)+1,Month(StartDate)+1, Day(StartDate))

I suspect that is too simple, OK for year one but years 2, 3 ... ??

The DateSerial function has the solution, but I will let you sort that!

DateSerial function is a very powerful/flexible function. I should look at the help file entry

MTB

edit

I have assume buy 'anniversary' you do mean the next year, as opposed to the next month you have indicated!?