Count the Days Between Today and Another Date in Excel

You can count the difference between today and a date by using the TODAY() function and subtraction.

If your date is earlier than today, you can use the following formula:

If you want to count how many days are left until the future date, you can use the following formula.

You can use addition and subtraction with dates because they are just numbers, which are formatted as dates. You can learn more about storing dates and times in Excel by reading the following article.

Tomasz Decker is an Excel specialist, skilled in data analysis and financial modeling.