Don’t know how to deal with table with dates? Want to handle it quickly and correctly? Use Excl IF formula with dates! When we are working in Microsoft Excel, various formulas offered by Excel make our work easier. Using appropriate formulas can save lods of time and enegry. IF formula is a frequently-used and convenient one. after reading the article, you will handle how to use the excel IF formula with dates. We will learn from two aspect, compare dates in two cells and compare dates in a cell with a certain date. Each part gets one example to help you handle excel IF formula with dates. Come and check!
Compare dates in two cells
When handing our work, sometimes we need to compare dates in two cells. But the dates are too much to deal with. How can we do? Excel IF formula with dates is a good way to do so.
EXAMPLE:
We need to compare the submission date with deadline, so that we can know if the person is on time or delayed. That’s when excel if formula with dates makes a difference.
Step 1 : Click cell D2
Step 2 : Insert IF formula, and call IF formula like this:
| = IF(B2<=C2,”On Time”,”Delayed”) |
Step 3 : Tap”Enter”, then you will get:
Step 4: drag the Fill Handle tool to cell D8, then you will get:
(Fill Handle tool is the plus sigh”+” in the bottom right of a cell)
Compare dates in a cell with a certain date
Due to different requirement or to make our table more brief and clear, sometimes there is only one date is stored and we need to compare it with a certain date. How to deal with it? Another method to use excel IF formula with dates can be a good solution. Here are how to use excel if formula with dates.
EXAMPLE:
Assume the deadline is “03/01/2023”. Now we need to know this 8 people is on time or delayed.
Step 1: Click C2
Step 2: Insert IF formula.To compare with certain date, we need to insert DATE formula or DATEVALUE formula. There are two different ways we can choose.
Combine IF formula with DATE formula:
call formula like this:
| =IF(B2<=DATE(2023,1,3),”On Time”,”Delayed”) |
Combine IF formula with DATEVALUE formula:
call formula like this:
| =IF(B2<=DATEVALUE(“2023/01/03″),”On Time”,”Delayed”) |
Step 3: Tap”Enter”,you will get:
Step 4: drag the Fill Handle tool to cell D8, then you will get:
(Fill Handle tool is the plus sigh”+” in the bottom right of a cell)
Compare dates in a cell with current date
When working, if you want to campare a date in a cell with current dates, there are another application in excel if formula with dates.
EXAMPLE:
Assume deadine is today, 2023/3/10. We need to know if these 8 person is on time or not.
Step1: Click C2
Step2: Insert IF formula and TODAY formula like this:
| =IF(B2<=TODAY(),”On Time”,”Delayed”) |
Step3: Tap”Enter”, you will get:
Step 4: drag the Fill Handle tool to cell D8, then you will get:
Learn More about How to Use IF Formula with Dates
Excel IF formula with dates is applied widely. It’s easy but useful. Sometimes we just need to follow the formula to quick get the right result. Sometimes we need to combine DATE function or DATEVALUE function with IF function. Then we can easily handle excel if formula with dates.
WPS Office is a good alternative to Mircosoft, which can well assit you with your work. Apart from strong and comprehensive function that support almost all of your work, WPS Offices also get WPS Academy to guide you have a good command of Excel skills easily. Furthermore, WPS is compatible and FREE to download. Don’t hesitate. Come and start a joyful and effective working journey with WPS Office!
