Add months to a date

[frank]

How would I add a X number of months to a date using vba?

 

[Graeme Richardson]

Hi Frank, use the DateAdd function. The follwing code will return the date
in 3 months time

Dim dtmNew As Date
dtmNew = DateAdd("m", 3, Now())