Convert month to number and subtract one

[Guest]

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

 

[Niek Otten]

I assume you have =TEXT(A1,"mmmm")

For November:
=TEXT(DATE(1,MONTH(A1)-1,1),"mmmm")
For October:
=TEXT(DATE(1,MONTH(A1)-2,1),"mmmm")

etc

 

[Niek Otten]

Better make that

=TEXT(DATE(2,MONTH(A1)-1,1),"mmmm")

etc