# How to calculate how many days left to or passed from the specific date in Excel

Excel
2016

For some projects or tasks, you might need to calculate how many days, months or years left to
some date or how many days, months or years passed from some date till today. Excel proposes very
useful formula that can help you to calculate that very fast.

The formula **DATEDIF** calculates days, months or years between two dates:

*= DATEDIF (<start date>, <end date>, unit)*

The parameter ** unit** can be:

**"D"**- The number of days between to dates.

For example:

- To calculate how many days
the date:*left to**= DATEDIF (<start date>, TODAY(), “d”)*:**Notes**- You can use a simpler formula that yields the same result:
*= TODAY() - <start date>* - The formula
**TODAY()**calculates current date. Sure, you can enter the specific date to calculate the differences, see Calculating the Number of Days between two dates.

- You can use a simpler formula that yields the same result:
- To calculate how many days
the date:*passed from**= DATEDIF (TODAY(), <end date>, “d”)*: You can use a simpler formula that yields the same result:*Note*= <end date> - TODAY().