Hi guys,
I know there has been some similar questions here before, but I do not find them applicable to my question here (at least those two I have seen).
Please see attached.
I have a given starting date (column B) and then some additional working days (days excluding weekends and holidays) I need to add on top of that to get no an "End date" (coulmn D). The idea here is to be able to put into column C how many working days there are between each milestone, and then automatically get a timetable.
I have inclded helping columns in colmun F through K, where the Norwegian holidays are included (which are applicable in this case).
My first thought was to use an Offset(Indirect()) formula to locate the cell of the date in the helping columt, and then subtotal to sum the number of weekdays and holidays to be added. However, my problem becomes how to sum the column until the value in column C is reached.
This might be a very bad explanation - please ask questions if that is the case. To be clear; the formula I am looking for should be applied in column D (which should not be the sum as it is currently). I have included the correct dates (which should be the output in column D) in column N.
Best,
Kristian
Edit: the file is updated after a comment by vletm.
I know there has been some similar questions here before, but I do not find them applicable to my question here (at least those two I have seen).
Please see attached.
I have a given starting date (column B) and then some additional working days (days excluding weekends and holidays) I need to add on top of that to get no an "End date" (coulmn D). The idea here is to be able to put into column C how many working days there are between each milestone, and then automatically get a timetable.
I have inclded helping columns in colmun F through K, where the Norwegian holidays are included (which are applicable in this case).
My first thought was to use an Offset(Indirect()) formula to locate the cell of the date in the helping columt, and then subtotal to sum the number of weekdays and holidays to be added. However, my problem becomes how to sum the column until the value in column C is reached.
This might be a very bad explanation - please ask questions if that is the case. To be clear; the formula I am looking for should be applied in column D (which should not be the sum as it is currently). I have included the correct dates (which should be the output in column D) in column N.
Best,
Kristian
Edit: the file is updated after a comment by vletm.
Attachments
Last edited: