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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEVALUE & Empty cells
Something like:
=IF(A2,WORKDAY(A2,B2,Holidays),"") See WORKDAY in Excel's Help. mla75 wrote: 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? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
DATEVALUE & Empty cells
Thanks Aladin,
I've already got the workday formula worked out, but the IF command has helped me get rid of the nonsense numbers. Here's the formula I used: =IF('C12=0,"***",'C12') The C12=0 provides the logic statement - if cell c12 is empty (or =0)... The next object provides instructions for what to do if the cell is empty - insert "***" - this way I can easily eye if the data isn't present and the next indicate what output is needed if the input cell has data Thanks! "Aladin Akyurek" wrote: Something like: =IF(A2,WORKDAY(A2,B2,Holidays),"") See WORKDAY in Excel's Help. mla75 wrote: 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? |
Reply |
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) |