View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Phrank Phrank is offline
external usenet poster
 
Posts: 153
Default 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