Sure. If the date is in A1, just put =A1 in the other cell. Then format the
cell to show the day instead of the date. The formula doesn't "show" the
day, the formatting of the cell does. :)
************
Anne Troy
www.OfficeArticles.com

"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?