Formula for dates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
one way:

A1: <hire date or last evaluation date>
A2: =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
 
If your hire date is in A1

=EDATE(A1,(DATEDIF(A1,NOW(),"y")+1)*12)

note EDATE is part of Analysis TolPak addin
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

next anniversary date 5
IF Statement Using Dates 6
Counting Dates 3
Comparing Dates 3
Recognizing specific dates with formula 2
Calculating time between mulitple dates 4
vacation accrual formula 2
Help with Conditional Formatting on Anniversary Date 2

Back
Top