Data not entered yet - formula calculate blank

G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Leaving a formula cell blank when data has not yet been added. 5
format a cell with a formula so an empty reference cell shows blan 3
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
ignore blank cells in a formula 1
No date entered still pulls a reult '1' through?? 1
don't calculate if no date is entered 3
Average Sum needs blank if no info 4
Leave Blank If No Data 6

Top