IF statement help

[afv123]

I'm trying to create an IF statement that displays a "Yes" if the difference between two dates is greater than or equal to 3 years. Can anyone assist?

 

[Joe4]

There are lots of different ways, and it depends on how you want to define a year.
Your could incorporate the DATEDIF function (see: DATEDIF function - Microsoft Support), or just do a simple subtraction of the date, i.e.

=IF(A1-A2>=1095,"Yes","")

Note that 1095 is 365*3, which is the number of days in 3 years (Excel stores dates as numbers, specifically the number of days so subtracting two dates will results in the number of days between the two).

 

[afv123]

Thx!

 

[Joe4]

You are welcome.
Glad I was able to help!