# 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.

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

`=INT(A1)=INT(B1)`

- 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.

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

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

- 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.

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

`=INT(A1)=INT(B1)`

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

Did you find this useful?