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 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 28, 2014 at 06:26 PM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jul 28, 2014 at 06:26 PM
Related:
- Need help comparing dates...
- Defcon dates - Guide
- How to highlight overdue dates in excel ✓ - Excel Forum
- Different dates of "end to end encryption message" on blank chat? - Internet & Social Networks Forum
- Vivatech 2024 dates - Guide
- Apple iphone 13 release dates - Guide
2 responses
Mazzaropi
Posts
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
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
1985
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
May 24, 2023
147
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