Derive correct month from time stamp

[kumara_faith]

Hi,

I have the following format of data:

a) 02/12/2018 0:00
b) 02/06/2018 12:00:00 AM

1) When I try to convert to month using =text(b1,"mmm"), it returns as Dec for set (a) and 02/06/2018 12:00:00 AM for set(b). As for set (a), the correct month is actually Feb and not Dec
2) As for set (b), I am not sure how to correct this to return the month

Appreciate any help.

 

[kumara_faith]

Hi,

Appreciate if anyone could help. Thank you.

 

[Scott Huish]

It worked fine for me.

The only way I can think of that you could return December for the first one is if your system settings are not set up for US style dates or your cell reference is wrong