Forum Discussion
IF Statement with Networkdays
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??
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))
4 Replies
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))
will this still remove the weekends along with the holidays i specified in the last part of formula?
Yes of course.
You can read this support https://support.office.com/en-us/article/workday-function-f764a5b7-05fc-4494-9486-60d494efbf33 to learn more about this function.
