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