| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEVALUE & Empty cells
I've created a table to calculate deadline dates in output cells based on a
specified number working days between the start date and the targeted deadline date (output). However, as many of the start dates have not yet been determined, one of the input cells is empty... while the formula recognizes this, it also uses 1/0/00 as the start date. Having these cells filled with a nonsense date is confusing. Is there anyway to get the formula to leave the output cell blank if any of the input cells are empty? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
| using functions empty cells | Excel Discussion (Misc queries) | |||
| Copy empty cells from one workbook to another - Code | Excel Discussion (Misc queries) | |||
| Excel - Autom. Filter "Empty / Non Empty cells" should come first | Excel Discussion (Misc queries) | |||
| how do populate empty cells with the contents of populated cells . | Excel Discussion (Misc queries) | |||
Threaded Mode
