Excel Formulas: Calculate dates overlap in days ~ A Complete Guide!!
Tags: excelformula, excelformulas
Published: 2021-05-01 08:27:07

---
title: Excel Formulas: Calculate dates overlap in days ~ A Complete Guide!!
published: true
date: 2021-04-30 14:49:01 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-calculate-date-overlap-in-days/
---

Supposing some date ranges are recorded in a sheet, and now you want to **calculate how many days or hours of those dates overlap with a specific date range** as the below screenshot showed. Except to compare date ranges and calculate one by one, I introduce a formula to quickly solve this task in Excel here in this article. Let’s get started!! 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 dates overlap days](https://geekexcel.com/wp-content/uploads/2021/04/Calculate-dates-overlap-days.png)](https://geekexcel.com/excel-formulas-calculate-date-overlap-in-days/calculate-dates-overlap-days/#main)<figcaption id="caption-attachment-34913">Calculate dates overlap days</figcaption>

## General Formula:

- You can use the below formula to calculate the dates which are overlap by a given date in Excel.

**=[MAX](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)([MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)(end1,end2)-MAX(start1,start2)+1,0)**

## Syntax Explanations:

- **MAX** – In Excel, the **[MAX function](https://geekexcel.com/how-to-use-excel-max-function-in-office-365-with-examples/)** will return the largest numeric value from the range of input values.
- **MIN** – This function helps to return the smallest numeric value from the range of input values. Read more on the [**MIN function**.](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)
- **End** – It specifies the ending date.
- **Start** – It represents the starting 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.

## Example:

Refer to the below example image.

- Here, we will enter the input values in **Column B** and **Column C**.
- Now we will find the overlapping of dates based on the criteria given in **Column F**.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/04/Input-Ranges-41.png)<figcaption id="caption-attachment-34915">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/04/Enter-the-formula-33.png)<figcaption id="caption-attachment-34914">Enter the formula</figcaption>

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

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

## Bottom-Line:

Hope you like this article to **calculate how many days or hours of those dates overlap with a specific date range**. Please share your **query** below in the **comment** box. We will assist you. Thank you so much for visiting our site. Click here to know more about **[Geek Excel](https://geekexcel.com/) **and [**Excel Formulas**](https://geekexcel.com/excel-formula/) **!!**

### Read Ahead:

- **[Excel Formulas to Add Workdays to Date with Custom Weekends!!](https://geekexcel.com/excel-formulas-to-add-workdays-to-date-with-custom-weekends/)**
- **[Excel Formulas to Add the Business Days to Date ~ Easy Guide!!](https://geekexcel.com/excel-formulas-to-add-the-business-days-to-date-easy-guide/)**
- **[Formulas to Round Prices to End in X.99 ~ Easy Tutorial!!](https://geekexcel.com/excel-formulas-to-round-a-price-to-end-in-x-99/)**