Forum Discussion

Copper Contributor

Mar 29, 2018

Solved

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: =I...

Formulas & Functions

IF formula combo error

Haytham Amairah
Mar 29, 2018
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))

Haytham Amairah

Silver Contributor

Mar 29, 2018

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))

R S
Copper Contributor
Mar 29, 2018
will this still remove the weekends along with the holidays i specified in the last part of formula?
- Haytham Amairah
  Silver Contributor
  Mar 29, 2018
  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.
  - R S
    Copper Contributor
    Mar 29, 2018
    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.