If 200901 was in cell A1, and 13 in B1, this formula:

=DATE(LEFT(A1,4)-INT(B1/12),RIGHT(A1,2)-B1+12*INT(B1/12),1)

should do what you want. I make it 01/12/07 (or 12/01/07 for America...) not
november 08 though.

Sam


"Memphis" wrote:

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