How would I add a X number of months to a date using vba?
G Graeme Richardson Aug 14, 2003 #2 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())
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())