G
Guest
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?
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?