Formula to yield number representing preceding month

Ludovico · May 9th, 2002, 09:19 AM

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. · May 9th, 2002, 09:23 AM

=MONTH(EDATE(A1,-1))

Dave Patton · May 9th, 2002, 09:25 AM

=MONTH(A1)-1

format as general or number

Mark W. · May 9th, 2002, 09:42 AM

Quote:

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

=MONTH(A1)-1

format as general or number

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 9th, 2002, 09:19 AM	#1
Ludovico Board Regular Join Date: Apr 2002 Posts: 66	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.

May 9th, 2002, 09:23 AM	#2
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	=MONTH(EDATE(A1,-1))

May 9th, 2002, 09:25 AM	#3
Dave Patton Board Regular Join Date: Feb 2002 Location: Calgary, Alberta Canada Posts: 2,065	=MONTH(A1)-1 format as general or number