Adding Months to Dates to create new value
=(DATE(YEAR(A1),MONTH(A1)+6,DAY(A1))) will give the answer you asked for in
that case, but the question in this type of problem is what you want as an
answer when you add 6 months to a date like 30 Aug 06.
--
David Biddulph
"simond" wrote in message
...
I have a column that contains various dates (xx/xx/xxxx) In a column next
to
this one I would like to add various # months to come up with a new date
8/1/2006 + 6months = 2/1/2007
Is this possible with formula?
Thanks
|