Counting Weeks INVOLVED between 2 dates

**GuruWannaB** · 11-03-2008, 05:31 PM

I've been having problems coming up with a formula that will take a start date and an end date and come up with the number of weeks INVOLVED within this date range (each week being a Sunday through Saturday). My problems is that the start and end dates could be any day of the week and not necessarily the same day (meaning divisible by 7 doesn't always work). I tried using ROUND((A2-A1)/7,0)+1 where A1 was the start date...and A2 was the end date. The problem I had was if I picked a Monday as the start date, and went 12 days out (The saturday of week2)...it came up stating 3 weeks were involved - AND if I selected a Friday start date and picked the following monday in week 2 - the result was 1 week involved when 2 different weeks were involved.

My brain is fried from data entry and I'm stuck. Any suggestions or beer would be greatly appreciated! Thank you in advance.

**Ron Coderre** · 11-03-2008, 05:42 PM

Try this:

Please Login or Register  to view this content.

Does that work for you?

**GuruWannaB** · 11-03-2008, 06:05 PM

I tried this...however it didnt work when I used the starting date of 11/7/2008(friday of week 1) and used the ending date of 11/10/2008 (Monday of week 2). Althought there is only a span of 4 days, they involve two seperate calendar weeks - so the output should have been 2 - when it came out as only 1.