Using datedif function to determine the difference between today() and another date in excel =DATEDIF(Today(),B4,”d”)