Weeks of school missed

[bmacias]

Start date in a2=4/1/2015 Return date in b2=10/31/2015. School Ends 5/31/2015 and Begins 9/1/2015; Therefore, this student missed between 17 to 20 weeks of school. I think it’s a matter of finding out the length of weeks between the start date and return date; then subtracting any weeks in the a2 and b2 range that fall in June, July and August. I just don’t know how to set-up the formula.

Your assistance is appreciated.

 

[Roxxien]

Your formula should be like this.

(School ends - Start date) + (Return date - School begins)

This will give 120 days.

If you use the weeknum function on each of those argument, you have 23-14 + 44-36 so 17 missed school week.

 

[bmacias]

What happens when the student was only out the first week of December? This returns a negative number when it should return a 1 for that one week missed.

(School ends - Start date) + (Return date - School begins)

=((5/31/2015-12/1/2015)+(12/7/2015-9/1/2015))/7 gives you -0.001355861

Is there another alternative to the formula?