I am trying to work out the end date given a start date and number of work days required from that date.
The networkdays function works for a start date and end date however I only have the start date and the days required.
If I simply add the days required to the start date it does not subtract weekends or holidays naturally.
Can anyone suggest a formula or method for achieving this.
The inputs are start date, days required and holiday dates. Assume weekends are unavaiable.
Many thanks in advance.