Extracting text string

monkeyharris

Active Member
Joined
Jan 20, 2008
Messages
310
Not sure what i'm doing wrong but I have a report which extracts from our system so the date field shows as:
22-11-2013 10:35:00 AM

I want to extract just the date and then show it as JAN, FEB, MAR etc.... for use in a Pivot Table. Any ideas???
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

ParamRay

Well-known Member
Joined
Aug 6, 2014
Messages
1,195
.
.

A date/time valuein Excel is essentially just a serial number. For example, 22/11/2013 10:35:00 is the same as 41600.4409722222. Here, the 41600 refers to the date part and .4409722222 refers to the time part.

So, suppose you have a date/time value in cell A1. Then this formula would extract the date part: =ROUNDDOWN(A1,0)

To format the resulting date in the way you want, you need to use the number format code mmm
 

Watch MrExcel Video

Forum statistics

Threads
1,109,028
Messages
5,526,335
Members
409,696
Latest member
EERS

This Week's Hot Topics

Top