|To head off the #NUM error, |
This way you check the contents of B3 before you try to do a calculation on it.
If B3 is blank, you simply make C3 blank.
If B3 is not blank, then do your WORKDAY calculation.
This will not eliminate the possibility of an error, but if you do get one, you know it has to be the Date in B3 that is the problem. (as I mentioned in my previous post)
Also the WORKDAY(B3-1,30) is actually only adding 29 days to the Date in B3
because the first part is B3 -1 which subtracts one day from the Date in B3,
then it adds 30 days, excluding just Weekends. Holidays are not accounted for.
This should allow you do remove the Conditional Formatting rule: =ISERROR(C3)
message edited by mmcconaghy