convert date to Day of the Week

R

Rick Rothstein

How can I convert a date to the 'Day of the week'? ie Mon, Tue

Let's say your date is in A1, then this...

=TEXT(A1,"ddd")

will give you the day's name abbreviated and this...

=TEXT(A1,"dddd")

will give you the full name of the day.

Rick Rothstein (MVP - Excel)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to tell day of week 2
Sorting day names chronologically 5
Day of week Fill down column not working 4
Finding the next dayof the week after a certain date. 4
Convert Month, Week, Year to date 2
Date, Day of week 6
Showing date as day of week 4
Convert Week number to Month 0

Top