Determining an annual review date from an employee start date
 

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

Determining an annual review date from an employee start date
 

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

Determining an annual review date from an employee start date
 

Beautiful. Thanks Max!

Frank

On Tue, 27 Nov 2007 21:10:21 +0800, "Max"
wrote:

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))

Determining an annual review date from an employee start date
 

welcome, Frank
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Phrank" wrote in message
...
Beautiful. Thanks Max!

Frank