Forum Discussion
Gumzz212
Sep 04, 2023Copper Contributor
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_EekelenPlatinum Contributor
Gumzz212 Wrap the formula that you have in an IF function. For example:
=IF(OR(ISBLANK(A1),ISBLANK(B1)),0,NETWORKDAYS(_________))