Basically discover your work correctly, If the formula will help resolve your condition: =IF(B1=”",TODAY()-A1,B1-A1) Guarantee this is what need