Formula to yield number representing preceding month

[Ludovico]

A1 contains function TODAY(). I would like a formula in A2 which yield the number of the month preceding, for instance if today's date is May 9, the formula in A2 would yield 4. If today's date is any day in June, the formula in A2 would yield 5, and so on. I will need to be able to divide other sets of numbers by the number in A2.
Any help will be appreciated.

 

[Mark W.]

=MONTH(EDATE(A1,-1))

 

[Dave Patton]

=MONTH(A1)-1

format as general or number

 

[Mark W.]

On 2002-05-09 08:25, Dave Patton wrote:


=MONTH(A1)-1

format as general or number

...and if A1 contains 1/1/2002?