In L3, put:

=DATEDIF(K3,TODAY(),"y")
and copy down

In K60, put:
=COUNTIF(L3:L58,"=5")


--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"andy" wrote in message
...
I have a list of employees and have calculated their retirement dates.
this
among other things are calculated on sheet 1 (labeled senioritylist). On
sheet 2 I want to calculate the percentage of employees that have reached
their retirement date or are within 5 years of retirement, and then do the
same in the 5-10 year retirment group, etc. I was trying to use
=countif(senioritylist!k3:k58,"(today()+365.25*5)" ) but that does not
work.
What am I doing wrong?
--
andy