Formula for dates
one way:
A1: <hire date or last evaluation date
A2: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
In article ,
"shunt" wrote:
I have hundreds of hire dates of employees I want a spread sheet showing each
persons evaluation date every 12 months from hire date, but all I want
calculated is the next evaulation date.
|