If you are looking forward to a formula where you can calculate the no. of days remaining in your project/ work etc. you have come at the right place.

Previously in Excel Tutorials:- How to sort data in ascending or descending order?

Let’s take an example to understand how to calculate the days remaining:

remaining days

As you can observe in the image above, we have our start date as well as last date which is enough to calculate the days remaining.

The formula to calculate the same is no special but very basic.

remaining days

The formula for the same is 

= Last date-Start date

remaining days

Now press “enter”.

Make sure that the format is in “general” mode and not “date” mode. 

remaining days

Now all you have to do is drag down the same so that you don’t have to jot down last date-start date again and again.

remaining days

It’s easy, isn’t it?