*63*

You can use the following formulas to create an IF function with dates in Excel:

**Method 1: Create IF Function to Compare Date in Cell with Specific Date**

=IF(A2

For this formula, if the value in cell **A2** is equal to or before 10/15/2022, the function returns “Yes.” Otherwise it returns “No.”

**Method 2: Create IF Function to Compare Dates in Two Cells**

=IF(A2B2, "Yes", "No")

For this formula, if the date in cell **A2** is equal to or before the date in cell **B2**, the function returns “Yes.” Otherwise it returns “No.”

The following examples show how to use each formula in practice.

**Example 1: IF Function to Compare Date in Cell with Specific Date**

Suppose we have a list of dates in Excel that show when some task was done and we want to know if each task was done by 10/15/2022:

We can type the following formula into cell **B2** to return “Yes” if the task in cell **A2** was done before or on 10/15/2022 or to return “No” otherwise:

=IF(A2

We can then drag and fill this formula down to each remaining cell in column B:

The formula returns either “Yes” or “No” depending on whether or not the date in column A is before or equal to 10/15/2022.

**Note**: The **DATEVALUE** function in Excel converts a date stored as a text value to a date that is recognizable by Excel formulas.

**Example 2: IF Function to Compare Dates in Two Cells**

Suppose we have two columns of dates in Excel that show when some task was done along with the task deadline:

We can type the following formula into cell **C2** to return “Yes” if the task in cell **A2** was done before or on the deadline in cell **B2** or to return “No” if it wasn’t:

=IF(A2B2, "Yes", "No")

We can then drag and fill this formula down to each remaining cell in column C:

The formula returns either “Yes” or “No” depending on whether or not the task in each row was done by the deadline.

**Note**: This formula assumes that both columns are formatted as dates (not text) in Excel.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Excel:

Excel: Calculate the Number of Months Between Dates

Excel: How to Calculate Sum by Date

Excel: How to Calculate Average by Date