Days Count From Specified Date

The union has instated a new policy here and new hires now have a 120 working day probationary period. That comes out to about 6 months. ( 168 days minus the 48 days off) . what I’m looking for is a formula that will calculate each date that has passed as one starting at a –48 … also adding in to the equation that every day sick counts against that 120 and everyday of OT counts as positive brining them closer to the 120 they need.

I can figure out the math part of adding and subtracting the days. But what I can’t figure out is how do I get it to read each date as one starting from the date in cell b3

Example cell b3 has 9/25/06 cell b4 has 3/12/07 all the days that have passed count as one.

The total starts as a –48( due to the days off) with the verabial, d8 is a negative and d9 is a positive. To be added in to the total.