I want to count 90 days from a given date including weekends. However, I do not want to count days when school is not in session. For example, from June 1st until August 15th should not be counted.
I want to count 90 days from a given date including weekends. However, I do not want to count days when school is not in session. For example, from June 1st until August 15th should not be counted.
With
A1: a start date....2019-07-15
and this list of dates to skip:
This regular formula returns the date that is 90 days from the start date, not counting the dates to skip:![]()
D1: 2019-06-01 D2: 2019-08-15
Note: this pattern "0000000" flags weekend days, beginning with Mondays, with 1's. 0's flag work days.![]()
B1: =WORKDAY.INTL(A1,90,"0000000",D1:D2)
In that example, the formula returns: 2019-10-14 (skipping 2019-08-15)
Is that something you can work with?
I can definitely work with this! Thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks