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.
________________________________________
The more questions I ask and the more I learn, I realize that I don't know squat!!!
Try
=DATE(YEAR(A1),MONTH(A1)+A2,DAY(A1))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
