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
RWomanizer Posts 365 Registration date Monday February 7, 2011 Status Contributor Last seen September 30, 2013 - Feb 23, 2012 at 04:27 AM
Related:
- Date format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- Whatsapp date format - Guide
- How to format hp laptop - Guide
1 response
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Feb 23, 2012 at 04:27 AM
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
=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
