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