How to Compare Dates Without Time in Excel

To compare dates without considering the time in Excel, you can use the following methods:

Method 1: Using the INT function

The INT function helps to extract the integer part of a number. In terms of dates, it removes the time component and leaves only the date.

1. Suppose you have two dates in cells A1 and B1, and you want to compare them without considering the time.
2. In any empty cell, enter the following formula:

=INT(A1)=INT(B1)

3. Press Enter. The result will be TRUE if the dates are the same and FALSE if they are different.

Method 2: Using the DATE function

The DATE function helps to create a date value from individual year, month, and day components.

1. Suppose you have two dates in cells A1 and B1, and you want to compare them without considering the time.
2. In any empty cell, enter the following formula:

=DATE(YEAR(A1), MONTH(A1), DAY(A1))=DATE(YEAR(B1), MONTH(B1), DAY(B1))

3. Press Enter. The result will be TRUE if the dates are the same and FALSE if they are different.

Example

Let's compare the dates "14-Jul-2021 14:30" in cell A1 and "14-Jul-2021 11:20" in cell B1 without considering the time.

1. Enter the dates in cells A1 and B1.
2. In any empty cell, use the INT function to compare the dates:

=INT(A1)=INT(B1)

3. Press Enter. The result will be TRUE because both dates are the same when we ignore the time component.