Check if a date is between two dates

If you want to check whether the particular date is between two other dates, you can easily do it in Excel.

In the following example, we have a few dates we want to check whether they fall between the start date and end date.

We are going to use the following formula to check the condition.

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

Formula explanation:

The formula checks whether a date is bigger than the start date and smaller than the end date. If both conditions are met it returns “Yes”.

If any of these conditions is wrong, the formula returns “No”.