convert date to Day of the Week

[APPLE]

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

 

[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)

 

[Don Guillett Excel MVP]

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

If the SAME cell just format it to ddd