| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Seniority Years Formula needed
Does anyone know the formula for calculating a person seniority years
i tried subtracting the End Date from Start date / 365 but because of leap years this does not accurately calculate. any ideas? Hire Date Current Date =(B2-A2)/365 08/01/1908 07/23/2008 100.04 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Scheduling staff to tasks based on seniority | Excel Discussion (Misc queries) | |||
| How to allocate based on seniority | Excel Discussion (Misc queries) | |||
| How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
| Recalc needed for successive years | Excel Discussion (Misc queries) | |||
| Overlay 4 years of data as a line on 4 years of columns for several x category labels | Charts and Charting in Excel | |||
Threaded Mode
