ExcelBanter - Formula for dates

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Formula for dates (https://www.excelbanter.com/excel-discussion-misc-queries/67166-formula-dates.html)

shunt

Formula for dates

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.

JE McGimpsey

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.

daddylonglegs

Formula for dates

If your hire date is in A1

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

note EDATE is part of Analysis TolPak addin

--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=504689

All times are GMT +1. The time now is 08:29 AM.