![]() |
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. |
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. |
All times are GMT +1. The time now is 03:56 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com