=IF(A2="",0,A2-TODAY())
Thank you! This worked perfect.=IF(A2="",0,DATEDIF(A2,TODAY(),"d"))
Thank you! This worked perfect too! Thank you for the explanation on how it works.Or more simply:
Excel Formula:=IF(A2="",0,A2-TODAY())
You can do this because Excel actually stores dates as numbers, specifically the number of days since 1/0/1900.
So since Dates are really stored as "days", you can simply subtract two dates to get the number of days between them.