PDA

View Full Version : Counting Forward x number of months from given date



Jarlisle
11-09-2009, 02:57 PM
I need a formula that will return the day x number of months from a given date. Meaning if I have 2/1/2009 in cell A1 and the number of months ahead in A2 at 3 and the formula in A3, I want the value to be 5/1/2009. Currently I have only used the date +30, but this gets off pretty fast.

Bob Phillips
11-09-2009, 03:01 PM
Try

=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))