Excel Formulas to Calculate All dates in chronological order!!
Tags: excelformula, excelformulas
Published: 2021-10-30 11:06:41

---
title: Excel Formulas to Calculate All dates in chronological order!!
published: true
date: 2021-10-30 02:02:30 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-calculate-all-dates-in-chronological-order/
---

Have you ever tried to find calculate all dates in chronological order? Here are some useful formulas for you to  **calculate all dates in chronological order ** in Excel. Let’s check out the simple formulas given 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)

## Generic Formula

- If you want to calculate all dates in chronological order, then you have to use the following  **formula**.

```
=IF([SUMPRODUCT](https://geekexcel.com/how-to-use-sumproduct-function-with-criteria-in-excel/)(--(range1>=range2))=0,"✓","")

```

## Syntax Explanation

- **Minus Operator (-)** – This symbol will help to subtract any two values.
- **Parenthesis ()** – The main purpose of this symbol is to group the elements.
- **Range 1**  – It represents the first input range in the Excel sheet.
- **Range 2**  – This will refer to the second input range.
- **SUMPRODUCT ** – This function helps to multiply the corresponding arrays or ranges and returns the sum of the products. Read more on the **[SUMPRODUCT Function](https://geekexcel.com/how-to-use-sumproduct-function-with-criteria-in-excel/)**.

## Practical Examples

- For instance, you have to **create a sample data** in Excel.

![](https://geekexcel.com/wp-content/uploads/2021/10/Sample-data-71.png)<figcaption>Sample data</figcaption>

- To check if a range of dates are in chronological order, you need to use a formula in the **[formula bar](https://geekexcel.com/how-to-use-formula-bar-for-various-purpose-in-excel-365/)**.

```
=IF([SUMPRODUCT](https://geekexcel.com/index-function-in-microsoft-excel-365-how-to-use/)(--(range1>=range2))=0,"✓","")

```

![](https://geekexcel.com/wp-content/uploads/2021/10/Use-the-Formula-22.png)<figcaption>Use the Formula</figcaption>

- Then, you will get the result as shown below in **cell H5**.

![](https://geekexcel.com/wp-content/uploads/2021/10/Result-in-cell-H5.png)<figcaption>Result for cell H5</figcaption>

- Now, you need to **copy down the formulas** to get the all dates in chronological order.

![](https://geekexcel.com/wp-content/uploads/2021/10/Final-Output-5.png)<figcaption>Final Output</figcaption>

## Summary

Hope you like this article on how to  **calculate all dates in chronological order ** in Excel. If you have any  **doubts** , feel free to let me know in the below  **comment**  section. 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:**

- **[Reverse Order of Characters in a Cell with Functions in Excel Office 365!!](https://geekexcel.com/reverse-order-of-characters-in-a-cell-with-functions-in-excel-office-365/)**
- **[Reverse Text String or Words Order in Excel Office 365!!](https://geekexcel.com/reverse-text-string-or-words-order-in-excel-office-365/)**
- **[Excel Formulas to Reverse Order of Characters in a Cell with Functions!!](https://geekexcel.com/excel-formulas-to-reverse-order-of-characters-in-a-cell-with-functions/)**
- **[How to Copy a Range of Cells in Microsoft Excel 365?](https://geekexcel.com/how-to-copy-a-range-of-cells-in-microsoft-excel-365/)**
- **[How to Print Pages in Reverse Order in Excel Office 365?](https://geekexcel.com/how-to-print-pages-in-reverse-order-in-excel-office-365/)**