# Google Sheets: How to Use an IF Function with Dates

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

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

```=IF(A2<=DATEVALUE("10/15/2022"), "Yes", "No")
```

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(A2<=B2, "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 Google Sheets 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<=DATEVALUE("10/15/2022"), "Yes", "No")`

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 Google Sheets converts a date stored as a string to a date that is recognizable by Google Sheets formulas.

## Example 2: IF Function to Compare Dates in Two Cells 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(A2<=B2, "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 Google Sheets.