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

Related:

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