Using an IF statement to compare dates

Question

Using an IF statement to compare dates

[Closed]

Report

Clay - Mar 15, 2016 at 12:27 PM
TrowaD

Posts: 2782
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 2, 2021

- Mar 15, 2016 at 01:05 PM

Hello,

I'm trying to compare two dates by referencing two cells.

I tried something like this IF(B2>C2, "past due", "on time").

I know to use the DATEVALUE function if I'm referencing a specific date. I want to reference the cells so those dates can change.

Using an IF statement to compare dates
If statement excel with dates - How-To - Excel
Need help comparing dates... ✓ - Forum - Excel
Comparing dates in multiple columns and using one that matches ✓ - Forum - Excel
IF statements with dates and criteria ✓ - Forum - Excel
Compare columns containing dates ✓ - Forum - Excel

1 reply

Ask a question

TrowaD · Answer 1 · 2016-03-15T13:05:45-0400

Answer 1 / 1

TrowaD

Posts: 2782
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 2, 2021

468
Mar 15, 2016 at 01:05 PM

Hi Clay,

A formula puts the result in the cell it is located. It cannot put the result in another location.

Best regards,
Trowa

Using an IF statement to compare dates

1 reply

Your reply

Subscribe To Our Newsletter!