| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Workaround for returning month name?
Hi all:
I'd like to return the month (Jan, Feb, Mar, etc.) from cells containing dates. Some variation of (formulas in column B): =IF(MONTH(A1)=1,"Jan",IF(MONTH(A1)=2,"Feb",... would be nice, but you can see the problem this gives, i.e. Excel allows a maximum of seven nested Ifs. I want to do this with a formula instead of VBA. Anyone have a suggested woraround for this? Thanks in advance. MARTY |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add one month to the previuos month | Excel Discussion (Misc queries) | |||
| Month Year Date Format | Excel Worksheet Functions | |||
| Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
| How to extract month number from month name | Excel Discussion (Misc queries) | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
Threaded Mode
