convert date to day of week in excel 2003

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Convert regular Date to Week Ending or Week Beginning Dates 4
Counting Days of Week 2
Calculating dates to include Saturdays but not Sundays 1
how many times a particular day of the week appears in a given month 4
NETWORKDAYS function 1
Need help filtering a date column 3
Reference blank cells in formula 7
Calculate Payment Days and Date 3

Top