Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
SIMPLE DATE FORMULA !
Thanks.
*** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help w/simple Date Formula please | Excel Worksheet Functions | |||
IF formula-simple question; simple operator | Excel Discussion (Misc queries) | |||
Simple problem, simple formula, no FUNCTION ! | Excel Worksheet Functions | |||
Most simple formula to calculate date+ 30 months? | Excel Worksheet Functions | |||
Simple (I Think) Date Formula Needed | Excel Discussion (Misc queries) |