Date format

Closed
Chinna - Feb 16, 2012 at 06:17 AM
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
- Feb 23, 2012 at 04:27 AM
Hello,

please advise me in Changing the date format

eg. from 10-02-2012 to 10th February, 2012

1 reply

RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Feb 23, 2012 at 04:27 AM
supoose your date in b4 column you can you followin formula.

=CONCATENATE(IF(OR(DAY(B4)=1,DAY(B4)=21,DAY(B4)=31),DAY(B4)&"st",IF(OR(DAY(B4)=2,DAY(B4)=22),DAY(B4)&"nd",DAY(B4)&"th"))," ",TEXT(MONTH(B4),"mmmm"),", ",YEAR(B4))

and you can change cell reference as your accordance
0