In this tutorial, you will learn how to compare dates without time in Excel.
Excel may be used frequently to compare two dates without ignoring the time values attached to the dates. Fortunately, you can simply compare dates without taking into account the time by using Excel’s INT() function to get just the date from a datetime value.
Once you are ready, we can start by using real-life scenarios to help you understand how to compare dates without time in Excel.
Table of Contents
Anatomy of INT Function
=INT(number)
The INT function helps to round off the number.
Compare Dates without Time in Excel
Before we begin we will need a group of data to be used to compare dates without time in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to check if all the projects are submitted on time before the cut off date on 31 January 2023. To do so, we will insert the following formula =IF(INT(A2)<=$D$1, “Pass”, “Fail”).
Step 3
Once you are done, the formula will return which submissions have passed or failed.
