Calculate calendar days w/o holidays

K

ku

Hi, I'm trying to add 8 days to a date - including
weekends but not including holidays. Any suggestions?
 
B

Bob Phillips

KU,

assuming your date is in E1, and the holidays are in J1:J10, try

=E1+8-SUMPRODUCT((J1:J10>=E1)*(J1:J10<=E1+8))
 
B

Bob Phillips

Daniel,

No I definitely meant subtract, as my reading was that the OP wanted to
avoid holidays.However, I think you are right in that I misinterpreted it,
and thus mine won't work for obvious reasons.
 

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

How to implement two shifts per day with multiple teams 0
Date Calculation Formula- Calendar days minus Holidays 1
How to Time time Diff for Completion of Activity (Exc Holiday List & Non Bus Hours) 2
Calculate next workday after adding calendar days to date in cell 13
Calculate days help 2
How to calculate dates 6
Calculate the number of days to exclude Sunday & Holidays 6
Date Calculation problem 3

Top