Hi,
Seeking additional brain power on this one. I need to calculate the number of weeks between the start of a quarter and the end of a quarter. Sounds easy right? I need to count only a full week Monday through Sunday. This is where I'm getting brain locked.
I was using this formula =INT(C2-B2)/7 but it does not take into consideration a full week Monday through to Sunday.
If you look at Jan, Feb, and Mar on a calendar and count the full weeks, Jan has 4, Feb has 3, Mar has 3 so the total count would be 10 complete weeks Mon-Sun week.
Here are my quarter start and end dates
start end
1/1/2017 3/31/2017
4/1/2017 6/30/2017
7/1/2017 9/30/2017
10/1/2017 12/31/2017
Seeking additional brain power on this one. I need to calculate the number of weeks between the start of a quarter and the end of a quarter. Sounds easy right? I need to count only a full week Monday through Sunday. This is where I'm getting brain locked.
I was using this formula =INT(C2-B2)/7 but it does not take into consideration a full week Monday through to Sunday.
If you look at Jan, Feb, and Mar on a calendar and count the full weeks, Jan has 4, Feb has 3, Mar has 3 so the total count would be 10 complete weeks Mon-Sun week.
Here are my quarter start and end dates
start end
1/1/2017 3/31/2017
4/1/2017 6/30/2017
7/1/2017 9/30/2017
10/1/2017 12/31/2017