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
Mazzaropi Posts 1983 Registration date Monday August 16, 2010 Status Contributor Last seen February 27, 2023 - Jul 28, 2014 at 06:26 PM
Related:
- Need help comparing dates...
- If statement with dates - Guide
- How to format dates in excel - Guide
- Numbers, text, dates, or times of day that you type into a cell. ✓ - Excel Forum
- Change file dates - Guide
- Convert dates with dots excel ✓ - Office Software Forum
2 replies
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
Jul 28, 2014 at 05:47 PM
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
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
Mazzaropi
Posts
1983
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
February 27, 2023
146
Jul 28, 2014 at 06:26 PM
Jul 28, 2014 at 06:26 PM
You're welcome.
I'm glad to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
I'm glad to help you.
--
Belo Horizonte, Brasil.
Marcílio Lobão
Jul 28, 2014 at 06:02 PM