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))
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Phrank" wrote in message
...
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