Calculate Workdays

Hi,

I have the following function:

=IF(G13="",IF(H13>1,1,IF(G13>1,workdays(H13,G13,Holidays))))


The intent is to calculdate the completion date against the assigned date as follows:

G13 - Typically the assigne date but sometimes can be blank because someone forgets or doesn't bother to insert

For this example, let's say: 12/17/12

H13 - Completion date

For this example, let's say: 12/20/12


I'm expecting a result of '3' for 3 days

The first half of the function is intended to calculate 1 day if G13 is blank or not defined. However, when I have dates in both cells, I'm getting a "false" answer instead of a numerical value that I'm expecting.

Please advise...


In our workplace, we do work weekends & sometimes 7 days a week.

Thanks