| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
convert date to name of month
My spreadsheet:
A B Results: C 1/5/09 =IF(A1="","",MONTH(A1)) 1 ? In Column C, I need to write a formula that says =IF($B1=1,"January"...) but my statement if FALSE, needs to be, IF($B1=2,"February" and so forth all the way through the calendar. The false will be if a new IF formula. I started with this, =IF($B1=1,"January",IF($B1=2,"February",IF($B1=3," March"))) And all the way down the line to December, with the correct # of close parens (12 of them) but I get an error. Do I need to keep typing in the "IF" for a false statement? Help please :) |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula convert date to month format | Excel Worksheet Functions | |||
| Convert date to number representing Month | Excel Discussion (Misc queries) | |||
| Convert date field to month in Pivot table | Excel Discussion (Misc queries) | |||
| How do I convert a month-date format to day number of the year? | Excel Worksheet Functions | |||
| Date arithmetic: adding 1 month to prior end of month date | Excel Worksheet Functions | |||
Threaded Mode
