day of the week entry automatically

D

DennyD

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

Alan

If the date is in A1 the formula in another cell is =A1 and format that cell
as Custom ddd or dddd
Regards,
Alan
 
A

Anne Troy

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
 
R

Ron Rosenfeld

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?
Click to expand...

Or, as a formula:

=TEXT(A1,"dddd")


--ron
 
Top