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:
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.
The formula for the same is
= Last date-Start date
Now press “enter”.
Make sure that the format is in “general” mode and not “date” mode.
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.
It’s easy, isn’t it?