| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
To get the month #, i.e., 1 for Jan, 6 for Jun, use
=MONTH(cell with date) If you want a text representation, i.e,. Jan or January for the 1st month, use =TEXT(cell with date,"mmm") or =TEXT(cell with date,"mmmm") "KC" wrote: I'm looking for an excel formula that looks at a cell containing a date and returns just the month of the date. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Value of formula field | Excel Worksheet Functions | |||
| How to sort/update large excel db | Excel Discussion (Misc queries) | |||
| Pivot Table Zero Value | Excel Discussion (Misc queries) | |||
| Help with Charting My Data -- | Charts and Charting in Excel | |||
Hybrid Mode
