Looking for a formula

[msxlvr]

Hi,

I maintain an Excel employee database at work and I need a function that
will determine when a new employee hired this year reaches the new year and
then adds 40 at that date.

There are already formulas that I wrote in place that determine how many
days Joe Bloe has been employed if that helps. Thanks!

 

[andy62]

You want to know the year only that is 40 years from a new employee's
"anniversary date" where anniversary date is defined as the next Jan 1 after
date of hire? I doubt I am grasping your need, but that's right doesn't this
do it:

=YEAR(A1)+41

Where A1 is the hire date (note this might not work for anyone hired on Jan
1, so if that's possible you'd have to trap for it with an IF statement).
You want to format the formula cell as "General", not as Date.

Like I said, maybe I am not grasping.