IF Statement with Networkdays

[R S]

i have a spreadsheet that has dates for a time frame and it has a "amount of days" that it has to be completed in while deducting for weekends and holidays.

Here is the formula i am using:

=IF(H4="","",NETWORKDAYS(H4,20,W4:AP4))

Formula resides in cell: I4

"H4" is the date 

"20" is the time it needs to be finished by

"W4:AP4" is where the holidays are stored

Am I doing something wrong??

[#2 · Accepted solution]

Hi,

The second argument of NETWORKDAYS function should be a date, not a whole number.

And this function gives you the net working days between two dates with taking into account the weekends and holidays and subtract from this net!

But I guess that you want to return the due date after a specific number of days (20) with taking into account the weekends and holidays!

If so, please replace this:

=IF(H4="","",NETWORKDAYS(H4,20,W4:AP4))

With this:

=IF(H4="","",WORKDAY(H4,20,W4:AP4))

[#3]

will this still remove the weekends along with the holidays i specified in the last part of formula?

[#4]

Yes of course.

You can read this support article to learn more about this function.

[#5]

Trust you experience and knowledge on this. (i did have my formula setup just like that and an assistant to my supervisor) went to him and told him her formula was more accurate.