Forum Discussion
Solved
Formula for End Date Based on specific hours per day
I need a formula to calculate the end date of a subject. The subject is 75 hours and it has the schedule below, and I need to exclude holidays. Please help.
Subject Start Date
4/6/2...
How about something like this (See attached example file)
How about something like this (See attached example file)
Wyn, as a comment - if you have same Running total for few days the formula returns last in the group date - since you use MATCH(,,1). More logically to return the first in the group date. i.e. END DATE is Thu, not Sun.
Good spot SergeiBaklan.
null null I have uploaded a revised version to handle the scenario flagged by Sergei
that is amazing, thank you so much
- You're welcome, please see the revised version below
