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 Contributor 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.

"Compare versions word"
View version history of Word document: SharePoint, OneDrive - Guide
Ms word mod apk for pc - Download - Word processors
Opening a word document in multiple versions - Word Forum
Beyond compare download - Download - File management
Ms word pdf extension - Download - Other

1 response

Answer 1 / 1

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Contributor 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

Macro to compare sheets(Jan & Feb), highlight the difference, copy the comme

How to compare two different columns

compare and count

Compare Fields

How to Compare two workbooks and see if data has moved or not?

Similar discussions

Subscribe To Our Newsletter!