• 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.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!