Formula for End Date Based on specific hours per day

[null null]

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/2018
Subject Total Hours	75
Hours on Monday	3
Hours on Tuesday	2
Hours on Wednesday	3
Hours on Thursday	2
Hours on Friday	0
Subject End Date

[#2 · Accepted solution]

How about something like this  (See attached example file)

[#3]

that is amazing, thank you so much

[#4]

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.

[#5]

Good spot @Sergei Baklan.

@null null I have uploaded a revised version to handle the scenario flagged by Sergei

[#6]

You're welcome, please see the revised version below