SIMPLE DATE FORMULA !
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! |
SIMPLE DATE FORMULA !
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" wrote in message ... 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! |
SIMPLE DATE FORMULA !
Thanks.
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
All times are GMT +1. The time now is 06:03 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com