Google Sheets – Number of Days Between Date and Today

You can calculate the number of days between two dates in Google Sheets by simply subtracting the earlier date from the later date, using cells containing the dates or the DATE function for manual input.

For dynamic calculations involving the current date, use the TODAY() function, as in =TODAY() - DATE(2024, 1, 12), to compute the days from a specific date to today, ensuring the result is always up to date.