Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I am trying to create a calculate that determines whether or not we
reach a date first or reach a number first. The calculation is for a retirement date of 30yrs which is in on cell and the other cell has a calcation for age & years of service. I want to determine whether or not the 30yrs date is reached before the age + service time reaches 80. I want to know which hits the target first. The set-up is as follows: Date of Birth Date Hired 30 yrs - using EDATE from date hired plus 360 months current age - using DATEDIF (dob cell,today,"Y") yrs of serv - using DATEDIF (date hired cell,today,"Y") age & serv - simply using current age + yrs of service cell) I am trying to show which cell arrives at its specific destination first: *does the 30yr cell (which is a date) arrive at 30yrs before *age & service arrive at 80 factor first which is a number. Hopefully this makes sense. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Can a cell change colors when the date entered arrives? | Excel Discussion (Misc queries) | |||
highlight dates when it arrives on a spreadsheet | Excel Worksheet Functions | |||
Cells will not calculate | Excel Discussion (Misc queries) | |||
cells will not calculate | Excel Worksheet Functions | |||
excel spreadsheet with e-mail notification when due date arrives | Excel Worksheet Functions |