Data not entered yet - formula calculate blank

D

DRondeau

I am using the workday function and want the formula to leave spaces blank
until information has been input into Excel. Right now it is showing a date
of Jan 5, 2000 and I do not want anything showing yet.
 
D

Dave O

Sounds like the "arguments" (input parameters) for your workday
function are in different cells that are referenced by the formula. Is
that correct?

If yes, you can write an IF statement along the lines of
=IF(A1<>"",WORKDAY(your arguments here),"")

This performs the workday calculation only if cell A1 is not blank.
 
Top