Previous Topic Next Topic

IF function with dates

Solved/Closed
ukie113 Posts 2 Registration date Monday March 25, 2013 Status Member Last seen March 25, 2013 - Mar 25, 2013 at 12:01 PM
ukie113 Posts 2 Registration date Monday March 25, 2013 Status Member Last seen March 25, 2013 - Mar 25, 2013 at 01:31 PM
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!


Related:

2 responses

Answer 1 / 2
Kevin@Radstock Posts 42 Registration date Thursday January 31, 2013 Status Member Last seen April 26, 2014 9
Mar 25, 2013 at 12:17 PM
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
Answer 2 / 2
ukie113 Posts 2 Registration date Monday March 25, 2013 Status Member Last seen March 25, 2013 1
Mar 25, 2013 at 01:31 PM
Thank you so much, Kevin@Radstock! It works perfectly
1

Similar discussions

help me to add particular cells
mathewmunna -
mathew munna -

2 responses
Dell laptop FN key is not working
adibah -
Artur -

93 responses
USB:\ is not accessible. Incorrect Function.
rickitikz -
Amar Yadav -

7 responses
Excel function question
1234ah -
ac3mark -

3 responses