Excel Formulas to Find the Next Scheduled Event Date from Today!!
Tags: excelformula, excelformulas
Published: 2021-05-19 11:41:22

---
title: Excel Formulas to Find the Next Scheduled Event Date from Today!!
published: true
date: 2021-05-18 15:00:14 UTC
tags: ExcelFormula,Excelformulas
canonical_url: https://geekexcel.com/excel-formulas-to-find-the-next-scheduled-event-date-from-today/
---

Microsoft Excel provides a ton of functions to work with dates and times. In this tutorial, we will learn how to **find the next scheduled event date from today’s date in Excel**. Let’s get 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)

[![Get next scheduled even date](https://geekexcel.com/wp-content/uploads/2021/05/Get-next-scheduled-even-date.png)](https://geekexcel.com/excel-formulas-to-find-the-next-scheduled-event-date-from-today/get-next-scheduled-even-date/#main)<figcaption id="caption-attachment-43803">Get next scheduled even date</figcaption>

## General Formula:

- You can use the below formula to find out the next scheduled date in Excel.

**{=[MIN](https://geekexcel.com/how-to-use-excel-min-function-in-office-365-with-examples/)([IF](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)((range>=[TODAY](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/)()),range))}**

## Syntax Explanations:

- **MIN** – This function will help 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/)**.
- **IF** – In Excel, the **[IF function](https://geekexcel.com/use-if-function-in-microsoft-excel-365-simple-steps/)** is used to return one value for a TRUE result, and another for a FALSE result.
- **TODAY** – To know the current date on your workbook, you can use the [**TODAY function**](https://geekexcel.com/how-to-use-excel-today-function-in-office-365-simple-steps/).
- **Range** – It specifies the input range from your worksheet.
- **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.

- Here, we have entered the events in **Column B** and scheduled dates in **Column C**.
- Now we need to find out the date of an upcoming event.

![Input Ranges](https://geekexcel.com/wp-content/uploads/2021/05/Input-Ranges-36.png)<figcaption id="caption-attachment-43804">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-59.png)<figcaption id="caption-attachment-43806">Enter the formula</figcaption>

- After that, Press **CTRL** + **SHIFT** + **ENTER** Keys, it will display the result as shown below.

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

## Conclusion:

Here, we have discussed how to **find**  **the next scheduled event date from today’s date in Excel**. If you have any **issue** regarding this article or any unresolved **query** , please comment in the **comment** box below. We will assist you.

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/) **!! **

### Related Articles:

- **[Excel Formulas to Calculate the Number of Months Between Two Dates!!](https://geekexcel.com/excel-formulas-to-calculate-the-number-of-months-between-two-dates/)**
- **[Excel Formulas to Calculate How Many Days Open? Easy Method!!](https://geekexcel.com/excel-formulas-to-calculate-how-many-days-open-easy-method/)**
- **[How to Find the Actual Price of the Discounted Price in Excel 365?](https://geekexcel.com/how-to-find-the-actual-price-of-the-discounted-price-in-excel-365/)**
- **[Enter the Date in Excel Sheet ~ Step-by-Step Procedure!!](https://geekexcel.com/enter-the-date-excel/)**