Forum

Notifications
Clear all

Converting a date to text

4 Posts
2 Users
0 Reactions
78 Views
(@alanr)
Posts: 79
Estimable Member
Topic starter
 

Hi there, hope everyone is well.

I am trying to figure out the most efficient way to extract the day from a date.  In the attached book you will see I have a date in column A; I want to add a column that displays the day of the week as a text value, that the date field in column A represents.  So for example if the date in column A is "7/24/2019" I want to have the text value "Wednesday" displayed in a separate column.

I have been messing with the TEXT function but can't get it to work.  Can someone help?

Many thanks,

Alan

 
Posted : 05/09/2019 9:08 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Hello Alan,

Check out this blog article for more tips and guidance.

The formula you want is =TEXT([@[Extract Date]],”dddd”)

 
Posted : 06/09/2019 12:30 am
(@alanr)
Posts: 79
Estimable Member
Topic starter
 

Thanks Anders, that worked, can't believe I couldn't figure that one out myself! 🙂

Maybe with the article I will be able to get it myself next time.  Thanks again.

 
Posted : 06/09/2019 9:11 am
Anders Sehlstedt
(@sehlsan)
Posts: 971
Prominent Member
 

Great that you got it to work!

I can only say that the blog articles here at MOTH are just great, those and the courses I have taken here have helped me a lot in my daily work.

 
Posted : 06/09/2019 2:56 pm
Share: