Thread: Need help with If-then statement with multiple conditions
View Single Post
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
FX[_2_] FX[_2_] is offline
external usenet poster
  
Posts: 1
Default Date based IF Statements
maybe you can help solve this one..

=IF(TODAY()=C3,0,NOW()-C3-1)

the days open are counted based on a start date manually inputed in C3, a closed date is manually inputed in a separate cell, for instance C4. I am trying to craft my IF statement to stop counting days open based on the closure date. Any suggestions?

Thx

Reply With QuoteReply With Quote