Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
How do I extract month and year to a single cell from a cell that contains dd/mm/yyyy hh:mm:ss?
By way of example: Cell A2 contains, 4/01/2011 11:25:30 AM Cell B2 to contain, Jan 2011 (However, it is not to carry over any of the non required data from cell A1.. That is, I don't want day or time) Outcome is a Pivot Table that tracks order fulfillment - Orders submitted in a month and completions for the month and months that follow. Mick |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do you extract day/time/month/year information | Excel Worksheet Functions | |||
count month when date is in day/month/year format | Excel Worksheet Functions | |||
Tell me which "season" (Month/Day through Month/Day) a date(Month/Day/Year) falls in (any year)??? | Excel Discussion (Misc queries) | |||
Sort month/date/year data using month and date only | Excel Discussion (Misc queries) | |||
trying to get day/month/year froamt while user enters year only | New Users to Excel |