Previous Topic Next Topic

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 December 27, 2022 - 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.

Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

How to compare two different columns
ABACUS -
TrowaD -

1 response
compare and count
vinod -
pcsces -

1 response
Compare Fields
Swapnil Arjun Veer -
Mazzaropi -

1 response