While working on 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 a year. In this tutorial, I will show you how to calculate the remaining days in Excel very easily.

**Table of Contents**Expand

## How to Calculate Remaining Days in Excel: 5 Methods

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.

### 1. Calculate the Remaining Days Using the Subtraction

We can simply use the subtraction method to calculate the remaining days in Excel.

**Steps: **

- We will write down the below formula in cell
**D5**.

`=MAX(0,C5-TODAY())`

**Formula Breakdown:**

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

**
**

- We will change the
**Number**format to**General**to get a numeric value. It 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.

** **

**Read More:Â **Excel Calculates Difference Between Two Dates in Days

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

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

**Steps: **

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

**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. - Like the first method above, we will 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.

- 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:Â **Excel Formula to Calculate Number of Days Between Today and Another Date

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

**Steps: **

- 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. - Like the methods above, we will change the
**Number**format to**General**. So we will get a numeric value that will indicate how many days are left in that month after the deadline 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 in the month after the deadline of each project.

** **

**Read More: **Calculate Number of Days Between Two Dates with VBA in Excel

### 4. Using the NETWORKDAYS Function 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.

**Steps: **

- 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**C5**contains the value in*Date*. - Following the methods above, we will change the
**Number**format to**General**. We will get a numeric value that will indicate how many workdays or weekdays are left after the deadline 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 workdays or weekdays in the month after the deadline of each project.

** **

**Read More:Â **How to Calculate Overdue Days in Excel

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

**Steps: **

- We will write down the below formula in cell
**D5**.

`=DATE(YEAR(C5),12,31)-C5`

**Formula Breakdown:**

- The
**YEAR**function calculates a year number from a date and it returns a 4-digit year of the corresponding date. - The
**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 the month argument, and*31*as the day. So the**DATE**function will return the date as*December 31, 2022*. - Finally, the formula will subtract the last date of the year which is
*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**. We will get a numeric value that will return the number of remaining daysÂ in that year after the deadline 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 in the year after the deadline of each project.

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

**Download Practice Workbook**

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

## 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 leave a comment below. Have a great day!!!

## Related Articles

- How to Calculate Working Capital Days in Excel
- How to Calculate Days Outstanding in Excel
- How to Calculate Average Tenure of Employees in Excel
- How to Calculate Tenure in Years and Months in Excel
- How to Calculate 90 Days from a Specific Date in Excel
- How to Create a Day Countdown in Excel

**<< Go Back to Days Between Dates | Calculate Dates | Date-Time in Excel | Learn Excel**