Forum Discussion

R S's avatar
R S
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's avatar
    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's avatar
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))

 

Resources