# Excel - IF Function Problem - Expert Solution

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
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.

Get instant expert help with Excel and Google Sheets

#### Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

## Click here to get your free Excelchat help session

Trusted by people who work at