View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
MyVeryOwnSelf MyVeryOwnSelf is offline
external usenet poster
 
Posts: 213
Default format a cell with a formula so an empty reference cell shows blan

I'm using the WORKDAY function. My formula is =WORKDAY(A1,10) to add
10 working days after the date an order is entered to show the due
date. How do I keep the cells showing up blank until an order date is
entered?


One way:
=IF(A1="","",WORKDAY(A1,10))