| 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 |
| 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 | |||
Threaded Mode
