IF function with dates [Solved/Closed]

Report
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 25, 2013
-
ukie113
Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 25, 2013
-
Hello,

I'm trying to compare cells with dates. For example:

column A column B column C
Mar-25 Apr-3 ?

In column C I need a function that compares column A with column B, and if date in column B is greater than the one in column A, then column C cell gets populated with the cell from column A. Basically, something like: =IF(Apr-3 > Mar-25), Mar-25,""

Can anyone help, please?

Thank you!


2 replies

Posts
42
Registration date
Thursday January 31, 2013
Status
Member
Last seen
April 26, 2014
9
Hi ukie113

Assuming your data starts in A1=Mar-25, B1=Apr-3

Try in C1 & copy down if required.

=IF(B1>A1,A1,"")
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3988 users have said thank you to us this month

Posts
2
Registration date
Monday March 25, 2013
Status
Member
Last seen
March 25, 2013
1
Thank you so much, Kevin@Radstock! It works perfectly
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 3988 users have said thank you to us this month