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.

Using an IF statement to compare dates
Fenix internet on bank statement - Guide
Beyond compare - Download - File management
An if statement nested within another if statement will produce how many possible results? - Guide
Excel if statement - Guide
Application for bank statement sbi - Guide

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

encryption message several time in chat

blank white page for website

IF statements with dates and criteria

using web browser page loads but screen blank

Conditional Formatting - highlight overdue dates

Similar discussions

Subscribe To Our Newsletter!