Previous Topic Next Topic

Need help comparing dates...

Solved/Closed
l_gavacho Posts 2 Registration date Monday July 28, 2014 Status Member Last seen July 28, 2014 - Jul 28, 2014 at 05:28 PM
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - Jul 28, 2014 at 06:26 PM
I have dates in one column, I want to enter a $0 value in another column if that date is >= 5 years in the past. Obviously, I'm a relative newbie with Excel functions beyond very basic stuff.

2 replies

Answer 1 / 2
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 146
Jul 28, 2014 at 05:47 PM
l_gavacho, Good evening.

Try to use:
=IF(DATEDIF(A1,TODAY(),"Y")>=5,0,"")

Is it what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0
l_gavacho Posts 2 Registration date Monday July 28, 2014 Status Member Last seen July 28, 2014
Jul 28, 2014 at 06:02 PM
Marcilio: Works like a charm, you are brilliant! Obrigado!
0
Answer 2 / 2
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 146
Jul 28, 2014 at 06:26 PM
You're welcome.
I'm glad to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0