Using an IF statement to compare dates

Closed
Clay - Mar 15, 2016 at 12:27 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - 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.

1 reply

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 544
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
0