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
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
- 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

Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
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
Mazzaropi
Posts
1963
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
April 25, 2022
147
Jul 28, 2014 at 06:26 PM
You're welcome.
I'm glad to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
0