Table of Contents
To check if a date falls between two specific dates in Excel, you can use the IF function along with the AND and logical operators. First, select a cell where you want to display the result. Then, use the IF function to set the condition that the date should be greater than or equal to the first specific date AND less than or equal to the second specific date. If the condition is met, the function will return a specified value, such as “Yes”, otherwise it will return “No”. This method allows you to easily determine if a date falls between two specific dates in Excel.
Excel: 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:
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:
Cite this article
stats writer (2024). How can I check if a date falls between two specific dates in Excel?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-check-if-a-date-falls-between-two-specific-dates-in-excel/
stats writer. "How can I check if a date falls between two specific dates in Excel?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-check-if-a-date-falls-between-two-specific-dates-in-excel/.
stats writer. "How can I check if a date falls between two specific dates in Excel?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-check-if-a-date-falls-between-two-specific-dates-in-excel/.
stats writer (2024) 'How can I check if a date falls between two specific dates in Excel?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-check-if-a-date-falls-between-two-specific-dates-in-excel/.
[1] stats writer, "How can I check if a date falls between two specific dates in Excel?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I check if a date falls between two specific dates in Excel?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.