Excel Formulas to Calculate How Many Days Open? Easy Method!!
Tags: excelformula, excelformulas
Published: 2021-05-10 07:08:01

---
title: Excel Formulas to Calculate How Many Days Open? Easy Method!!
published: true
date: 2021-05-08 06:52:02 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/
---

Excel has some powerful functions to calculate the number of days between two dates in Excel. Assume that you have two range of dates that defines an opening and closing date. Now you have to **find how many days are open?** Here we will show the formulas to get it done. Let’s see them below!! 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 number of days open](https://geekexcel.com/wp-content/uploads/2021/05/Calculate-number-of-days-open.png)](https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/calculate-number-of-days-open/#main)<figcaption id="caption-attachment-37629">Calculate number of days open</figcaption>

## General Formula:

- You can use the below formula to calculate the number of days that have been open in Excel.

**=[IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)([ISBLANK](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/)(closed),[TODAY](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)()-opened,closed-opened)**

## Syntax Explanations:

- **IF** – This function will help to return one value for a **[TRUE](https://geekexcel.com/use-true-function-in-microsoft-excel-365-simple-methods/)** result, and another for a **[FALSE](https://geekexcel.com/use-false-function-in-microsoft-excel-365-simple-methods/)** result. Read more on the **[IF Function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)**.
- **ISBLANK** – In Excel, the **[ISBLANK function](https://geekexcel.com/how-to-use-isblank-function-in-microsoft-excel-365/)** returns TRUE when a cell contains is empty, and FALSE when a cell contains any text or not an empty case.
- **TODAY** – To know the current date on your workbook, you can use Excel’s [**TODAY function**](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/).
- **Opened** – It represents the opening date.
- **Closed** – It specifies the closing date.
- **Comma symbol (,)** – It is a separator that helps to separate a list of values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.

## Practical Example:

Refer to the below example image.

- First, we will enter the input dates in **Column B** and **Column C**.
- Here we need to count how many days opened based on the given input dates.

[![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-12.png)](https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/input-ranges-144/#main)<figcaption id="caption-attachment-37627">Input Ranges</figcaption>

- Select any cell and type the above-given formula.

 

[![Enter the formula](https://geekexcel.com/wp-content/uploads/2021/05/Enter-the-formula-23.png)](https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/enter-the-formula-132/#main)<figcaption id="caption-attachment-37626">Enter the formula</figcaption>

- Finally, press  **ENTER**  to get the result out, if you need, drag the fill handle over range to apply the formula.

[![Result](https://geekexcel.com/wp-content/uploads/2021/05/Result-23.png)](https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/result-304/#main)<figcaption id="caption-attachment-37628">Result</figcaption>

## Conclusion:

Hope you like this article on **calculating the number of days open in Excel**. Let me know your worthwhile **feedback** in the below **comment** section. Please share your experience about this article!!

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 Also:

- **[Excel Formulas to Convert the Text Timestamps into Time ~ Easy Ways!!](https://geekexcel.com/excel-formulas-to-convert-the-text-timestamp-into-time/)**
- **[How to Format Text or Characters as Superscript/Subscript in Excel 365?](https://geekexcel.com/how-to-format-text-or-characters-as-superscript-subscript-in-excel-365/)**
- **[Excel Formulas to Count Dates in Current Month ~ Simple Tutorial!!](https://geekexcel.com/excel-formulas-to-count-dates-in-current-month-simple-tutorial/)**