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 a 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 passed from the date:

    = DATEDIF (<start date>, TODAY (), “d”)

    Number of days passed from some date in Excel 365

    Notes:

    1. You can use a simpler formula that yields the same result:

      = TODAY () - <start date>

    2. The formula TODAY () calculates the current date. Sure, you can enter the specific date to calculate the differences, see Calculating the Number of Days between two dates.
  • To calculate how many days left to the date:

    = DATEDIF (TODAY (), <end date>, “d”)

    Number of days left to some date in Excel 365

    Note: You can use a simpler formula that yields the same result:

    = <end date> - TODAY ().

See also this tip in French: Comment calculer le nombre de jours restants ou passés à partir de la date spécifique dans Excel.

Please, disable AdBlock and reload the page to continue

Today, 30% of our visitors use Ad-Block to block ads.We understand your pain with ads, but without ads, we won't be able to provide you with free content soon. If you need our content for work or study, please support our efforts and disable AdBlock for our site. As you will see, we have a lot of helpful information to share.