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

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

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

Hi,

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

Change cell reference A2 to suit...

Regards,

Gav.

"MTro" wrote:

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

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

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

FormatCellsNumber tabUnder 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.

"MTro" wrote:

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