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!