Date "yyyymm"
=DATE(YEAR(A2),MONTH(A2)-13,DAY(A2))
and format the result cell to meet your needs! But 200901 - 13 months
results in 200712 and not 200811. If you want 200711 then
=DATE(YEAR(A2),MONTH(A2)-14,DAY(A2))
--
Regards!
Stefi
€˛Memphis€¯ ezt Ć*rta:
I have a worksheet were the dates are displayed as 200901 (yyyymm --- no
slash) in column A.
I need to add a formula to cells in colum C that will only substract any
given number of months from this date, such as 200901 minus 13 months will
equal 200811. Now, on the same boat, I would like to show the new date
displayed as 11/01/2008.
Thank you
|