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.
You expect 2 possible results: 1. Number of workdays between 2 dates; or 2. Empty text (“”). Thus, your first formula should work as you desire except that you must change minus sign (-) to comma (,) in your NETWORKDAYS formula.