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