Forum Discussion

Gumzz212's avatar
Gumzz212
Copper Contributor
Sep 04, 2023

Networkdays

Im trying to count workdays between two date, but can we make the function work just when the two column is filled
and not work when just one of the column is filled?

1 Reply

  • Riny_van_Eekelen's avatar
    Riny_van_Eekelen
    Platinum Contributor

    Gumzz212 Wrap the formula that you have in an IF function. For example:

    =IF(OR(ISBLANK(A1),ISBLANK(B1)),0,NETWORKDAYS(_________))