Thread: Date "yyyymm"
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Memphis Memphis is offline
external usenet poster
 
Posts: 32
Default Date "yyyymm"

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