| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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)) |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| variable annual wage increases based on start date | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
| Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
| Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
| Employee review form | Excel Worksheet Functions | |||
Linear Mode
