Convert date of birth in word [Solved/Closed]

Report
-
Posts
47398
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 27, 2020
-
Hello,

pls tell me formula for convert date of birth in word in excel

1 reply

Posts
47398
Registration date
Monday February 1, 2010
Status
Moderator
Last seen
November 27, 2020
9,603
Download addon MOREFUNC from https://download.cnet.com/Morefunc/3000-2077_4-10423159.html

and then use this formula
=TEXT(A1, "MMMM") & " " & NBTEXT(TEXT(A1, "d")) & ", " & NBTEXT(TEXT(A1, "YYYY"))
6
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!