Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Recalculated Employment Dates
Hi,
I need to calculate the days between two dates (inclusive) then subtract the result from a third date and return a fourth date. For example, a person hired at company X on 7/20/2006 & left company X on 2/1/07 had 196 days of employment (2/1/07 €“ 7/20/06 equals 196 (if my math is correct)). The same person was rehired on 7/31/08 and I need to subtract 196 days from 7/31/08 which should return a date value of 1/18/08. What is the most accurate formula to use which will take into account months that have 28, 30, and/or 31 days? Thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to prevent a worksheet from being recalculated? | Excel Worksheet Functions | |||
formula help: calculate length of employment | Excel Worksheet Functions | |||
formula for lenght of employment based on hire date | Excel Worksheet Functions | |||
Formula used to calculate daily employment hours ... | Excel Worksheet Functions | |||
Formula used to calculate daily employment hours ... | Excel Worksheet Functions |