You can use the following formula to check if a date in Excel is between two specific dates:

=IF(AND(A2>=$F$1,A2<=$F$2),"Yes","No")

This particular formula returns “Yes” if the date in cell **A2** is between the start date in cell **F1** and the end date in cell **F2** or “No” otherwise.

The following example shows how to use this formula in practice.

**Example: Check if Date is Between Two Dates in Excel**

Suppose we have the following dataset in Excel:

Suppose we would like to check if each date in column A is between **2/10/2022** and **5/10/2022** and return “Yes” or “No” accordingly in column C.

We can type the following formula into cell **C2** to do so:

=IF(AND(A2>=$F$1,A2<=$F$2),"Yes","No")

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

The formula returns “Yes” or “No” to indicate whether or not each cell in column A falls between the specific start and end dates.

For example:

**1/4/2022**does not fall between the start and end dates so the formula returns**No**.**2/15/2022**does fall between the start and end dates so the formula returns**Yes**.

And so on.

**Note**: You can return values other than “Yes” or “No” by replacing these values in the formula with different text.

**Additional Resources**

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

How to Compare Dates Without Time in Excel

How to Use SUMIFS with a Date Range in Excel

How to Filter Dates by Month in Excel