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.

**Table of Contents**hide

**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.

**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**.

- 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.

** **

**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.

** **

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

** **

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

** **

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

** **

**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())`

**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.

** ****Step 2: **

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

** **

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

**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.

- 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.

**Step 2: **

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

** **

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

** **

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

**Similar Readings:**

**How to Calculate Average Tenure of Employees in Excel****Excel formula to Calculate Age on a Specific Date****Calculate Overdue Days in Excel (3 Methods)****3 Suitable Excel Formula to Count Days from Date****Number of Months Between Two Dates in Excel: 5 Easy Ways to Find**

**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.

- 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.

** **

**Step 2: **

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

** **

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

** **

**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.

- 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.

**Step 2: **

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

** **

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

**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!!!