how to advance dates by one year then up to 10 yrs in Excel
What do you want, to advance 3 months or a year like you state in your
subject line
If you have a date in A1 then you can add 3 months like this
=DATE(YEAR(A1),MONTH(A1)+3,Day(A1))
do the same with a year
=DATE(YEAR(A1)+1,MONTH(A1),Day(A1))
now depending on the day of the month you can get unexpected results for
instance if the date you want to add 3 months to is 11/30/07 then the date
will come out as 03/01/08. There are remedies for this if you want the last
date of February instead.
=MIN(DATE(YEAR(A1),MONTH(A1)+{3,4},DAY(A1)*{1,0}))
--
Regards,
Peo Sjoblom
"chaplyn" wrote in message
...
Doing an amortization table beginning with 10/2007 want to quickly advance
the dates quarterly for the next 10 years.
Thanks
|