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?

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?

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?