Excel: How to Check if Date is Between Two Dates

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:

Excel check if date is between two dates

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.

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