Number of days between past date and current date in Google spreadsheet April 28, 2023 by Tarik The following seemed to work well for me: =DATEDIF(B2, Today(), "D")