How to count differance in year between two dates in microsoft excel?

example: I have two different dates in column A %26amp; B. I want to count the differance in year between these two dates in column C. How to count it in microsoft excel.

How to count differance in year between two dates in microsoft excel?
The DATEDIF function computes the difference between two dates in a variety of different intervals, such number of years, months, or days. This function is available in all versions of Excel since at least version 5/95, but is documented in the help file only for Excel 2000. For some reason, Microsoft has decided not to document this function in any other versions. DATEDIF is treated as the drunk cousin of the Formula family. Excel knows it lives a happy and useful life, but will not speak of it in polite conversation. Do not confuse the DATEDIF worksheet function with the DateDiff VBA function.





The syntax for DATEDIF is as follows:





=DATEDIF(Date1, Date2, Interval)





Where:


Date1 is the first date,


Date2 is the second date,


Interval is the interval type to return.

flower shops