The reverse of NETWORKDAYS?

[diamondgeezer1974]

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

 

[Krishnakumar]

Hi,

Try,

=WORKDAY(A1,2)

A1 houses the start date.

 

[diamondgeezer1974]

Absolutely fanstatic!

Thanks for that,

I've learnt something new today!

Many thanks

DG

 

[rmtaylor]

Krishnakumar

I just logged on to your old reply.
just to pass on thanks for the assistance
your reply helped me out

Regards
Robert