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/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 |
How about something like this (See attached example file)
5 Replies
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
