Determining an annual review date from an employee start date

  • Thread starter Thread starter Phrank
  • Start date Start date
P

Phrank

Hi,

I have four:

A = Name
B= Employee Start Date
C= 6monthReview
D= AnnualReview

I want to put a formula in columns C and D based off of the Employee
start date, but the dates that pop up in these columns need to be for
the current year. For example, if 'Bob' started on 1 May 2002, I need
for 1 May 08. I intend on applying conditional formatting to flag
reveiw dates as they approach, and I want to be able to sort the list
based on these dates. Thanks for any help.

Frank
 
In B2: Employee Start Date, eg: 1 May 2002

In C2:
=DATE(YEAR(TODAY()),MONTH(B2)+6,DAY(B2))

In D2:
=DATE(YEAR(TODAY()),MONTH(B2),DAY(B2))
 
Back
Top