How to Calculate Remaining Days in Excel (5 Methods)

While working with a project in Excel that has a deadline to meet, you might want to find out how many days from today are left until the deadline. You might also need to find out how many days or workdays are left in a month or in a year. In this tutorial, I will show you how to calculate remaining days in Excel very easily.


Download Practice Workbook

Download this practice book to exercise the task while you are reading this article.


5 Methods on How to Calculate Remaining Days in Excel

Let’s assume a scenario where we have an Excel file that contains information on the Start Date and End Date of different projects. We will use this worksheet to calculate the remaining days in Excel. The image below shows the worksheet we are going to work with.

How to Calculate Remaining Days In Excel


Method 1: Calculate Remaining Days Using the Subtraction

We can simply use subtraction to calculate the remaining days in Excel. Let’s see how we can do that.

Step 1:

  • We will write down the below formula in cell D5.
=MAX(0,C5-TODAY())

Formula Breakdown:

  • TODAY function will return the date of the present day. The arithmetic expression C5-TODAY() will subtract the End Date of the project (C5) from the date of the present day.
  • The MAX function will return the subtracted value if it is positive. If the date of the present day exceeds the End Date. if the deadline of the project is over, then the MAX function will return zero (0) instead of a negative value.

Using the Subtraction

  • Upon pressing ENTER, we will see that the subtracted value has been returned in Date format as the two values involved in subtraction are in Date format.

Apply the DAYS Function in Excel to Calculate Remaining Days Between Two Dates

Step 2:

  • We will now change the Number format to General so that we will get a numeric value that will indicate how many days from the present day are left until the deadline of the project.

Calculate Remaining Days Using the Subtraction

  • After changing the Number type to General, we will get the remaining days of the project.

Calculate Remaining Days Using the Subtraction

  • Now, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

drag the fill handle

  • Finally, we will get the remaining days for all of the projects.

Calculate Remaining Days Using the Subtraction

Related Content: How to Subtract/Minus Days from Today’s Date in Excel (4 Simple Ways)


Method 2: Apply the DAYS Function in Excel to Calculate Remaining Days Between Two Dates

Alternatively, we can also use the DAYS function in Excel to calculate the remaining days.

Step 1:

  • We will write down the below formula in cell D5.
=DAYS(C5,TODAY())

Formula Breakdown:

  • TODAY function will return the date of the present day.
  • DAYS function will subtract the End Date of the project (C5) from the date of the present day.

DAYS Function in Excel

Note: Like the first method, if you want the DAYS function to return zero (0) instead of a negative value, you have to replace the existing formula with the one below.

=MAX(0,DAYS(C5,TODAY()))

  • Upon pressing ENTER, we will see that the subtracted value has been returned in Date format as the two values involved in subtraction are in Date format.
  • So, like the first method above, we will now change the Number format to General so that we will get a numeric value that will indicate how many days from the present day are left until the deadline of the project.
  • After changing the Number type to General, we will get the remaining days of the project.

Apply the DAYS Function in Excel to Calculate Remaining Days Between Two Dates

 Step 2:

  • Now, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

drag the fill handle

  • Finally, we will get the remaining days for all of the projects.

Apply the DAYS Function in Excel to Calculate Remaining Days Between Two Dates

Read More: How to Calculate Years Between Two Dates in Excel (2 Methods)


Method 3: Calculate Remaining Days in a Month Using the EOMONTH Function in Excel

We can also calculate the remaining days in a month using the EOMONTH function in Excel. We have to follow the below steps.

Step 1:

  • We will write down the below formula in cell D5.
=EOMONTH(C5,0)-C5

Formula Breakdown:

  • EOMONTH function will return the last date of the month of cell C5.
  • Then the last date of the month will be subtracted from the End Date (C5) to determine how many days will be left in that month following the deadline of the project.

EOMONTH Function in Excel

  • Upon pressing ENTER, we will get the subtracted value in Date format as the two values involved in subtraction are in Date format.
  • So, like the methods above, we will now change the Number format to General so that we will get a numeric value that will indicate how many days are left in that month after the deadline of the project.
  • After changing the Number type to General, we will get the remaining days of the project.

Calculate Remaining Days in a Month Using the EOMONTH Function in Excel

Step 2:

  • Now, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

Calculate Remaining Days in a Month Using the EOMONTH Function in Excel

  • Finally, we will get the remaining days in the month after the deadline of each project.

Calculate Remaining Days in a Month Using the EOMONTH Function in Excel

Read More: How to Count Months in Excel(5 ways)


Similar Readings:


Method 4: Using the NETWORKDAYS Function in to Calculate Remaining Work Days in a Month

We can also determine how many workdays are left in a month. For that, we just have to change the formula above a little bit to add a function called NETWORKDAYS with it. We will follow the below steps to do that.

Step 1:

  • We will write down the below formula in cell D5.
=NETWORKDAYS(C5,EOMONTH(C5,0))

Formula Breakdown:

  • EOMONTH function will return the last date of the month of cell C5.
  • Then the last date of the month will be subtracted from the End Date (C5) to determine how many days will be left in that month following the deadline of the project.
  • Finally, the NETWORKDAYS function in Excel will determine how many workdays or weekdays are left in that month following the deadline of the project.

Using the NETWORKDAYS Function

  • Upon pressing ENTER, we will get the value in Date format as the C5 contains the value in Date.
  • So, like the methods above, we will now change the Number format to General so that we will get a numeric value that will indicate how many workdays or weekdays are left after the deadline of the project.
  • After changing the Number type to General, we will get the remaining workdays or weekdays of the project.

Using the NETWORKDAYS Function in to Calculate Remaining Work Days in a Month

Step 2:

  • Now, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

Using the NETWORKDAYS Function in to Calculate Remaining Work Days in a Month

  • Finally, we will get the remaining workdays or weekdays in the month after the deadline of each project.

Using the NETWORKDAYS Function in to Calculate Remaining Work Days in a Month

Related Content: Excel Add Months to Date (4 Easiest Examples)


Method 5: Combination of the DATE and YEAR Functions to Calculate Days Left in a Year

Alternatively, we can also use the combination of DATE and YEAR function to calculate the remaining days in a year. We will do the following.

Step 1:

  • We will write down the below formula in cell D5.
=DATE(YEAR(C5),12,31)-C5

Formula Breakdown:

  • The Excel YEAR function calculates a year number from a date and it returns a 4-digit year of the corresponding date.
  • DATE function returns the date with the given year, month, and day. We have provided the DATE function with the 4-digit year of the corresponding date C5 as the year argument, 12 or December as month argument, and finally 31 as day So the DATE function will return the date December 31, 2022.
  • Finally, the formula will subtract the last date of the year December 31, 2022, from the End Date (C5) of the project to determine the remaining days in that year following the deadline of the project.

Combination of DATE and YEAR Functions

  • Upon pressing ENTER, we will get the value in Date format as the C5 contains the value in Date.
  • So, like the methods above, we will now change the Number format to General so that we will get a numeric value that will return the number of remaining days in that year after the deadline of the project.
  • After changing the Number type to General, we will get the remaining days in that year.

Combination of DATE and YEAR Functions to Calculate Days Left in a Year

Step 2:

  • Now, we will drag the fill handle of cell D5 to apply the formula to the rest of the cells.

drag the fill handle

  • Finally, we will get the remaining days in the year after the deadline of each project.

Combination of DATE and YEAR Functions to Calculate Days Left in a Year

Read More: How to Calculate Years in Excel from Today (4 Ways)


Quick Notes

🎯 You have to change the number format to General format from Date format each you apply any of the formulas above.

🎯 Like the first method, if you want the DAYS function to return zero (0) instead of a negative value, you have to replace the existing formula with the one below.

=MAX(0,DAYS(C5,TODAY()))

Conclusion

In this article, we have learned how to calculate the remaining days in Excel. I hope from now on you can calculate the remaining days in Excel very easily. However, if you have any queries or recommendations about this article, please do leave a comment below. Have a great day!!!


Related Articles

ASM Arman

ASM Arman

Hi there! I am ASM Arman. I Completed B.Sc. in Naval Architecture and Marine Engineering. I take a great interest in learning about new technologies and sharing my ideas and thoughts on them with others. Please do reach out to me if you have any queries or recommendations. Have a great day!!!

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo