display number of years based on a date

Hi all, you've all been a lot of help so far with my project.

Right now, in a column I would like to display an number (length of employment) based on the hire date.

In one cell the employee's hire date is entered. In a column of other cells the pay period ending date is displayed and in another column the length of employment is displayed.

Example:

03/17/2000


03/01/2009 8
03/15/2009 8
03/29/2009 9
04/12/2009 9
04/26/2009 9

How would I create a formula in the length of employment cells that would indicate the correct number of years based on the hire date and adjusts when the pay period date passes this hire date?

The DATEDIF function would tell you the number or years:

=DATEDIF($A$1, A4, "y")

But it wouldn't take the date into consideration. If you use it to count months instead it may be more accurate.

=DATEDIF($A$1, A4, "m")/12

But since that gives fractions, too, you wrap that in an INT() function and you're good to go.

=INT(DATEDIF($A$1, A4, "m")/12)

Format that cell as General. This appears to work for all your sample data.