Thread: Need IF/THEN formula for date present
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Amatuer Amatuer is offline
external usenet poster
  
Posts: 2
Default Need IF/THEN formula for date present
I'm sure this is basic for most of you but it is baffling me:

I need a formula to subtract date column 1 from date column 2 (that part I
have) AND IF there is NOT a date in date column 2, subtract date column 1
from TODAY's date. Thanks!
Reply With QuoteReply With Quote