IF NETWORKDAYS formula with one date?

[hollyperret]

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!

[benishiryo]

welcome to the forum, hollyperret. try:
=IF(OR(A1="",NETWORKDAYS(A1,B1)<=2),"Met","Miss")

[Chris 53]

Wrap your formula in another if statement.

if(a1="","met", your formula)

[hollyperret]

Thanks so much for the quick response and for the welcome!

Both of those worked. Now I don't have to look at the calendar or manually enter the results for hundreds of date ranges. Thank you. Thank you.

[hollyperret]

One more question. Is there a way to make it enter nothing if neither cell has a date in it? I know I can just leave out the formula, but I want to put it in so I don't have to add it every time I enter dates. As it is, it enters "Met" when it sees nothing in both cells. The amount of "Met" entries are added up and this will skew results, unless I add the formula every time.

[Tony Valko]

Maybe this...

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