Extracting text string

[monkeyharris]

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???

 

[ParamRay]

.
.

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

 

[XOR LX]

Hi.

=INT(A1)

Format cell as mmm.

Regards