Formula to Indicate name of day (Sunday, Monday etc..) based on a Date

D

dannboy213

Can someone help me figure out the formula for showing the name of da
based on a date
 
N

Niek Otten

Just Format>Cells>Number>Custom tab. In The Type box, enter ddd or dddd
This leaves the date a date. Alternative in another cell:

=TEXT(A1,"ddd")

This makes the cell text.
 
P

Pete

You could just format the cell containing the date using custom set to
dddd. If you want to see the day and the date, you could custom format
the cell as dddd, dd/mm/yyyy (UK format).

Alternatively, if you want to show the day in a separate cell and your
date is in A1, enter this formula in cell B1:

=WEEKDAY(A1)

and format this cell as custom dddd.

Hope this helps.

Pete
 
K

Kevin B

I all you want is the day of the week, this will do the trick...

=CHOOSE(MOD(DateValue,7),"Sun","Mon","Tue","Wed","Thurs","Fri","Sat")

So, if your date is in A1 the formula would be entered as:

=CHOOSE(MOD(A1,7),"Sun","Mon","Tue","Wed","Thurs","Fri","Sat")
 
Top