Convert days numbers to words
Hi,
I need to insert the Day Name in a cell B based on the date in Cell A
so if the date it 22-Jul-2021 then in Cell B I want to display "twenty-second" and so on for different days, I am attaching an excel workbook, with 2 sheets one of them contains the days list in numbers and words.
Hope it help, I tried but I couldn't as I'm just learning Excel, Thanks for helping
In B2
Formula:
Please Login or Register to view this content.
Does that work for you?
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Please try
=INDEX(Table1,DAY(A2),2)&TEXT(A2," of mmmm ")
Thanks a lot, works perfectly
Hi,
One way
Formula:Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
If you would like to eliminate the lookup table, you can use this formula to directly calculate the ordinal day number...
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks