Date & Day of Week

L

Ltat42a

I have a simple time sheet for calculating my hours worked for a two
week pay period. In one column, I have the dates of the pay period. In
the next column, I have the day of the week.

Is there a formula I can use that will auto insert the day of the week
according to the date I insert in the date column?

DATE WEEKDAY
D4=Date E4=???


Thanx.
 
R

Ron de Bruin

Hi

Use =D4 in cell E4

Then format the cell like this
Select E4
Format>Cells in the men bar
Custom on the number tab and fill in dddd
 
Top