Forum Discussion

Nikoss's avatar
Nikoss
Copper Contributor
Nov 02, 2020
Solved

IF statement with OR and NETWORKDAYS

Hello I have some trouble adding the OR function to this statement: =IF(AD3="","",NETWORKDAYS(AC3,AD3)) So far I am saying that if AD3 is blank then the result should be blank otherwise the resul...
BI & Data Analysis
excel
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Nov 02, 2020

    Nikoss 

    Use

    =IF(OR(AD3="",AF3="Yes"),"",NETWORKDAYS(AC3,AD3))
hezb158's avatar
hezb158
Copper Contributor
Aug 05, 2024

Riny_van_Eekelen using the same principal how would I use this if I were to calculate my networking days from TODAY and past dates?

Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Aug 05, 2024

hezb158 This thread was about how to write an OR function. Better to start a new thread with your own question relating to the NETWORKDAYS function.

Resources