M
Montenegro Mick
How do I extract month and year to a single cell from a cell tha
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 cel
A1.. That is, I don't want day or time)
Outcome is a Pivot Table that tracks order fulfillment - Order
submitted in a month and completions for the month and months tha
follow.
Mic
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 cel
A1.. That is, I don't want day or time)
Outcome is a Pivot Table that tracks order fulfillment - Order
submitted in a month and completions for the month and months tha
follow.
Mic