Expiration Date by Month

[JohnnyZ]

I need to calculate a date by a certain number of months later; i.e. if the date is April 5,2005, I need a date exactly 6 months later. How can I make a calculation that will account for 30, 31, 28, or 29-day months?

[comment]

The question is not clear: in order to add "exactly 6 months" to DateX, use:

Date ( Month ( DateX ) + 6 ; Day ( DateX ) ; Year ( DateX ) )

If your question is concerned with DateX being, say August 31 (which will produce March 3 in the formula above), that is another matter.

[JohnnyZ]

Thanks, that is the general formula I was looking for.