| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If, then, else question.
This is my dilema... I need to display a status of 1 month previous and 2
months previous. My problem arises in January and February. What I need in the statement for current month - 1 is: If month(today()) = 1, then 12, else month(today())-1. What I need for the statement current month -2 is: If(month(today()) = 1, then 11, If month(today())= 2, then 12, else month(today())-2. I'm just not certain how to write this in Excel. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Is this the proper place to ask my question? | Excel Discussion (Misc queries) | |||
| Finding and deleting question marks | Excel Discussion (Misc queries) | |||
| Summary Page Question | Excel Discussion (Misc queries) | |||
| Pivot table question | Excel Discussion (Misc queries) | |||
| How do I find and replace a question mark in Excel? | Excel Discussion (Misc queries) | |||
Threaded Mode
