How to calculate "End Date" with the input of Start Date & No. of days

[theambarish]

Hi Gurus,

Formula to calculate "End Date" with the input of Start Date & No. of days?
Note - only week days are to be considered.
For example

Start Date No of Days End Date Notes
A B C

#1 27/3/2009 4 ??? Ignore weekends
Ignore holiday of 28/3/2009

 

[SteveO59L]

Have a look at the workday() function

 

[KSTWS]

or NETWORKDAYS function.

 

[SteveO59L]

I think that Networkdays, calculates the number of days between 2 dates, which isnt what the OP was after

 

[james_lankford]

I think that Networkdays, calculates the number of days between 2 dates, which isnt what the OP was after

holy crap I just figured out what that is

I've always read that as
network days
and i've never understood why the function has that name

but I read this thread and it just clicked
net workdays
duh !

 

[KSTWS]

I think that Networkdays, calculates the number of days between 2 dates, which isnt what the OP was after

Sorry. you are right.
But james liked the answer.