diamondgeezer1974
Board Regular
- Joined
- Oct 11, 2004
- Messages
- 161
Hi Guys
Ok, we all know that NETWORKDAYS gives you the amount of working days between 2 dates (excluding holidays that are determined).
What I'm after is the reverse of this.
ie. I Have a StartDate, and I want to find out what the date will be if I add x amount of Networkdays.
Eg:
If the StartDate was the 13th April (Thursday before Good Friday), I would expect 13/04/2006 + 2 = 19th April (because the 14th to the 17th are either weekend or Bank Holidays).
Is there a way I can utilise Networkdays to do this for me?
Regards
DG
Ok, we all know that NETWORKDAYS gives you the amount of working days between 2 dates (excluding holidays that are determined).
What I'm after is the reverse of this.
ie. I Have a StartDate, and I want to find out what the date will be if I add x amount of Networkdays.
Eg:
If the StartDate was the 13th April (Thursday before Good Friday), I would expect 13/04/2006 + 2 = 19th April (because the 14th to the 17th are either weekend or Bank Holidays).
Is there a way I can utilise Networkdays to do this for me?
Regards
DG