View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Deeds
 
Posts: n/a
Default Convert month to number and subtract one

I have a date in cell A1 of December 1, 2005. I do a =text(A1) and it
returns December. I want to now get November, October in other cells based
off of the December cell. How can I subtract from December to get November?
Thanks in advance