| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Data not entered yet - formula calculate blank
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Data not entered yet - formula calculate blank
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Array formula returns blank in the cell where it is entered | Excel Worksheet Functions | |||
| ranking query | Excel Discussion (Misc queries) | |||
| Excel Macro to Copy & Paste | Excel Worksheet Functions | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| blank data field shows quote in formula, how to delete it? | Excel Discussion (Misc queries) | |||
Linear Mode
