Hello,

I need to write a formula that calculates the days between two dates and then enters a word as a result under specified criteria. So if the calculated dates are equal to or less than 2 work days I want it to say "Met". If the dates are more than 2 work days apart, I want it to say "Miss".

For example:

If column A has the date 10/9/13 and column B has the date 10/10/13, then column C would say "Met". If column A has the date 10/9/13 and column B has the date 10/11/13, then column C would say "Miss".

I have been able to do this with the following formula in cell C1:

=IF(NETWORKDAYS(A1,B1)<=2,"Met","Miss")

It mostly works correctly, except I am having one issue. Occasionally, the A1 cell will be empty and the only reference is the B1 cell. In that case, the formula is defaulting to "Miss" but I need it to default to "Met". How can I get it to do this?

Hope that made sense. Thanks!