If the date is in A1 the formula in another cell is =A1 and format that cell
as Custom ddd or dddd
Regards,
Alan
"DennyD" wrote in message
...
I have placed the date in one cell, but I need to enter the day of the week
automatically in another cell. Got a formula?