Workday Error #VALUE!

  • Thread starter Thread starter Tufail
  • Start date Start date
T

Tufail

Hello,
I am using this formula in cell D1 =IF($A1="","",WORKDAY(B1,C1))
B_1 has Date and C-1 has credit days value like 10 and i want Due Date in
D_1 cell but problam is that whenever B_1 doesn't have any value then #VALUE!
error is coming out which i really don't want !
Thanks in advance.
 
One way to do it is to use an IF statement:
=IF(ISERROR(your_formula_here),"",your_formula_here)

Plain English translation: if the formula returns an error, return a
""; if it returns a non-error result, return that result.

Dave O
Eschew Obfuscation
 
Dear Dave O,
Thanks for your reply, but sorry not understant well, you means formula
would be is as under ?
=IF(ISERROR(WORKDAY(B1,C1),"",WORKDAY(B1,C1))
If so then this is not working !
 
You forgot the closing parenthesis for ISERROR. Dave means:
=IF(ISERROR(WORKDAY(B1,C1)),"",WORKDAY(B1,C1))

Regards,
Fred
 
Back
Top