Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculate review date
My employees receive bi-annual reviews. I know how to write a formula
to add six months to the hire date (in cell G2) to get the next review date in cell G3. However, once the next review date is passed I want the date in cell G3 to add another six months so that it always reflect the next review date. I will then conditionally format the cell to identify when I am two weeks or less from the next review date. I hope this is clear enough. Any suggestions? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
if cell has date value how to calculate other cell values | Excel Discussion (Misc queries) | |||
Mileage Claim Formula | New Users to Excel | |||
Auto calculate for date + days forward to yield new date | Excel Worksheet Functions | |||
How to calculate "number of months" between two given date? | Excel Worksheet Functions | |||
formula to calculate age using birth date and current date | Excel Worksheet Functions |