You can use the Year(date) function to return the year
--
http://HelpExcel.com
1-888-INGENIO
1-888-464-3646
x0197758


"Dave" wrote:

I am building a vacation calendar at work and have come across a minor flaw
in my programming. As people reach the different milestones (5 years, 10
years...) their vacation time changes and for the most part the
"=DATEDIF(A2,B2,"y")" statement I have works but the real formula for our
vacation schedule is "The YEAR that a person crosses a milestone they are
eligible for more days not their service date"

The question is how can I extract the YEAR ONLY from a date to use for my
formula?

--
Thanks
Dave