Ok, I want to have Sheet1 display Employee Name (A1), Date of Hire (B1) and
Years of Service (C1). then in each row show the info like this example:

Employee Name, Date of Hire, Years of service
Mike shmo, 4/10/2000, 8

I have this Sheet1 done and the code im using to get the "Years of service"
is
=DATEDIF(B2,TODAY(),"m")/12.

Now what i cant figure out is Sheet2 that will auto populate whos
aniverseries from Sheet1 that are in the current month and display them just
like they are in Sheet1.

Thanks,
Chad