Hey All,

I hope this is not a dumb question. Given any date, what calculation should I use to get the first date of the seventh month. So for example, given date 6/4/05 how do I get to 8/1/05 or 9/1/05 or 10/1/05. Thanks for the help in advance.

Phamacom

Hi,
try:

DateSerial(Year(YourDate), Month(YourDate)7,1)

HTH
Good luck

Thank you so so so so much. It worked.

You're welcome
Glad I could assist.
Good luck on future projects!