function to return day in the form "Monday", "Tuesday" etc given .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello. What function in excel will return the day in the form "Monday",
"Tuesday" et given a date. Or, if it has to be by cell formatting, how do I
do it? Thanks
 
Hi,

In the cell where you want your day of the week type =TEXT(A2, "dddd")

Change cell reference A2 to suit...

Regards,

Gav.
 
You can also select the cells where you are entering the dates and set a
custom format by...

Format>Cells>Number tab>Under category select custom and in the type box
enter dddd.

Now when you enter a date in the cells the correct day will be displayed..

Regards,

Gav.
 
Back
Top