Question description:
This user has given permission to use the problem statement for this
blog.
I need a datedif function that calculates the difference in 2 dates and if it returns more than 5 years, I need it to say yes and if not no.
Solved by O. Y. in 14 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
27/03/2018 - 02:58
Hi there
User
27/03/2018 - 02:58
Hi
Excelchat Expert
27/03/2018 - 02:58
How are you and how amy i assist you with today?
User
27/03/2018 - 02:59
i NEED A DATEDIF FORMULA THAT CALCULATES whether the difference between 2 dates is more or less than 5 years
Excelchat Expert
27/03/2018 - 02:59
OKAY
User
27/03/2018 - 02:59
if it is more than 5 years i ned it to return yes and if its less than 5 years i need it to return no
Excelchat Expert
27/03/2018 - 03:00
OKAY, will surely help you with this
User
27/03/2018 - 03:00
All in one formula hopefully
Excelchat Expert
27/03/2018 - 03:01
mmhhm
Excelchat Expert
27/03/2018 - 03:01
will try my best
User
27/03/2018 - 03:01
I can get the days figured out but I want it to just say yes or no in the cell
Excelchat Expert
27/03/2018 - 03:03
so in this example answer should be "yes" right?
User
27/03/2018 - 03:04
correct
Excelchat Expert
27/03/2018 - 03:04
Great!
Excelchat Expert
27/03/2018 - 03:04
Please give me a while, will share the formula shortly
User
27/03/2018 - 03:04
ok
Excelchat Expert
27/03/2018 - 03:06
Please have a look
[Uploaded an Excel file]
Excelchat Expert
27/03/2018 - 03:07
Is that nice?
User
27/03/2018 - 03:07
I am testing the formula
Excelchat Expert
27/03/2018 - 03:07
Okay, sure
User
27/03/2018 - 03:09
Works PERFECTLY!!!!!!! YAY
Excelchat Expert
27/03/2018 - 03:09
Great,
Please do a valuable rating for me
Excelchat Expert
27/03/2018 - 03:10
that would help me a lot
User
27/03/2018 - 03:10
First time on here so how do i do it?
Excelchat Expert
27/03/2018 - 03:11
after you end the session you will get the options to rate
Excelchat Expert
27/03/2018 - 03:11
Thanks for being in Got it Pro!
User
27/03/2018 - 03:11
OK great! You will get the best rating
Excelchat Expert
27/03/2018 - 03:11
Have a nice day!
User
27/03/2018 - 03:11
You too
Excelchat Expert
27/03/2018 - 03:11
:)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.