convert date to day of week in excel 2003

M

medicineman

Hi there,
I have got a set of dates in a column and want to calculate overtimes for
the Saturdays and Sundays so how can I find them from numerical dates
automatically
Thank you
 
M

MyVeryOwnSelf

I have got a set of dates in a column and want to calculate overtimes
for the Saturdays and Sundays so how can I find them from numerical
dates automatically
Click to expand...

Look in Excel's built-in Help for the WEEKDAY() function.

Maybe something like
=WEEKDAY(A1,2)>5
will meet the need.
 
Top