Excel Formulas to Calculate Remaining Days ~ A Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-05-10 13:45:20

---
title: Excel Formulas to Calculate Remaining Days ~ A Complete Guide!!
published: true
date: 2021-05-08 07:26:48 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formula-calculate-remaining-days/
---

For certain cases, you may want to know the number of remaining days in a month or a year. How could you deal with this task in Excel? Here are some cute formulas for you to **calculate the remaining days in Excel**. Let’s jump into this article!! Get an official version of ** MS Excel**  from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

[![Calculate remaining days](https://geekexcel.com/wp-content/uploads/2021/05/Calculate-remaining-days.png)](https://geekexcel.com/excel-formula-calculate-remaining-days/calculate-remaining-days/#main)<figcaption id="caption-attachment-37658">Calculate remaining days</figcaption>

## General Formula:

- If you want to calculate the days remaining from one date to another, you can use the below formula.

**=end\_date-start\_date**

## Syntax Explanations:

- **End\_date** – It represents the ending date on your worksheet.
- **Start\_date** – It represents the starting date on your worksheet.
- **Minus Operator (-)** – This symbol will help to subtract any two values.

## Practical Example:

Let’s consider the below example image.

- Here we will enter the input dates in **Column B** and **Column C**.
- Now we need to find the remaining dates from these inputs.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-13.png)<figcaption id="caption-attachment-37656">Input Ranges</figcaption>

- So, apply the above-given formula to the [**formula bar**](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/) section and press the  **ENTER**  key.

![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-24.png)<figcaption id="caption-attachment-37655">Enter the formula</figcaption>

- Finally, we will get the result in the selected cell.

![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-24.png)<figcaption id="caption-attachment-37657">Result</figcaption>

## Wrap-Up:

In this chapter, we have described the easiest way to **calculate the remaining days in Excel**. Hope you like it. We welcome your **comments** and **questions** about this lesson. Don’t forget to share your worthwhile **feedback** with us.

Thank you so much for visiting  **[Geek Excel](https://geekexcel.com/)!! **If you want to learn more helpful formulas, check out [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!! **

### Read Ahead:

- **[Excel Formulas to Calculate the Years Between Dates ~ Simple Tricks!!](https://geekexcel.com/excel-formulas-to-calculate-the-years-between-dates/)**
- **[How to Highlight All Errors Using Macros (VBA) In Excel Office 365?](https://geekexcel.com/how-to-highlight-all-errors-using-macros-vba-in-excel-office-365/)**
- **[What is a Name Box and Its Features in Microsoft Excel 365?](https://geekexcel.com/what-is-a-name-box-and-its-features-in-microsoft-excel-365/)**
- **[Excel Formulas to Convert date into Julian’s Date Format [Simple Tricks]](https://geekexcel.com/excel-formulas-to-convert-date-into-julians-date-format/)**