View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Aladin Akyurek
 
Posts: n/a
Default 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?