Using an IF statement to compare dates

[Closed]
Report
-
Posts
2782
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
August 2, 2021
-
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.

1 reply

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

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

Best regards,
Trowa

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!