LinkBack URL
About LinkBacks
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:
Please Login or Register to view this content.
Note: this pattern "0000000" flags weekend days, beginning with Mondays, with 1's. 0's flag work days.Please Login or Register to view this content.
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)
Posting Permissions
Register To Reply
Bookmarks