Thread: Don't run formula if cell is blank
View Single Post
  #1   Report Post  
Randy Mis Randy Mis is offline
Junior Member
  
Posts: 6
Default Don't run formula if cell is blank
I have a formula for tracking completion dates that works great, but if the cell is blank the formula sends back date showing the item is over due. How do I get the formula to not run if the cell is blank?

=IF($E3<TODAY(),TODAY()-$E3&" Days Overdue","")

Cell e3 is the date the item is due.
Reply With QuoteReply With Quote