SIMPLE DATE FORMULA !

[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~


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

 

[Bob Phillips]

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)

 

[flex zax]

Thanks.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!