Count Workday include Saturday

  • Thread starter Thread starter TCLehmann
  • Start date Start date
T

TCLehmann

I would like to return the total number of days including saturday
excluding sunday between two dates. We have a 6day work week and to
calulate items per week would need the result of days based on 6 day
work week between 2 dates. Can anyone help - I noticed that this has
been posted before but I was not able to locate any reply.
Thank you
 
=SUMPRODUCT(INT((end_date-WEEKDAY(start_date+1-{2;3;4;5;6;7})-start_date+8)/
7))

This formula is inclusive, just as NETWORKDAYS is, so if you don't want
that, subtract 1.

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

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

Get Number of Date between two date but not include Saturday/Sunday 1
NETWORKDAYS including Saturdays 21
week numbers 3
Working days between 2 dates 3
workdays 2
Networkdays including Saturday? 5
Count items based on two criteria 7
Calculate workdays for irregular work patterns 1

Back
Top