Jul 05 2019 11:07 AM
I am trying to count how many working days in between two dates, but I don't want the formula to return any value, if one of the dates is missing. This is because my data is incomplete and I want to average out the amount of dates something takes.
For example:
Assigned project: 05/05/2019
Completed project: 10/06/2019
I tried multiple options but no avail:
=IF(OR(ISBLANK(J13),ISBLANK(K13)),"", NETWORKDAYS(K13-J13))
=OR((ISBLANK(Z2),ISBLANK(AJ2),""),(NETWORKDAYS(Z2,AJ2)))
Thank you for your help!!!
Jul 05 2019 11:17 AM