Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |