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!