SIMPLE DATE FORMULA !

  • Thread starter Thread starter flex zax
  • Start date Start date
F

flex zax

I need two formulas:

1. One that always shows only the month number of the current month in
cell A and
2. One that always shows only the month number of the previous month in
cell B

For example-
In January 2004, cell A will show 1 and cell B 12.

In March 2004, cell A will show 3 and cell B 2.

I would appreciate any help.Thanks.

~Flex~
 
A1: =MONTH(TODAY())
B1: =MONTH(DATE(YEAR(TODAY()),A1,0))

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
 
Back
Top