Count days in date range

shagivan · Post by **shagivan** » Sat Jan 26, 2019 8:41 pm

Hi all,
I'm trying to find number of Mondays and Saturdays in a date range. Could some assist with the formula pls.
For eg: between 01/01/19 and 31/01/19 how many Mondays and Saturdays. I found no of week days using NETWORKDAYS. but I need it for everyday.
Please advice
Thanks

edit this topic's initial post · Post by **Villeroy** » Sat Jan 26, 2019 10:23 pm

Count_Weekdays.ods: (16.77 KiB) Downloaded 112 times

shagivan · Post by **shagivan** » Sun Jan 27, 2019 9:45 am

That gives one day less in all day counts

edit this topic's initial post · Post by **Villeroy** » Sun Jan 27, 2019 1:06 pm

Yes, that's right because the division counts the the time spans between the Xdays. Just append +1 to the last formula.

lader · Post by **lader** » Sun Jan 27, 2019 2:16 pm

Code: Select all

= INT(($C$4-2)/7) - INT(($C$3-2)/7) + (MOD($C$4-2; 7)>=$C$5) + (MOD($C$3-2; 7)<=$C$5) - 1

C3 - Start date
C4 - End date
C5 - Select number from 0 to 6 for monday, tuesday, etc.

edit this topic's initial post · Post by **Villeroy** » Sun Jan 27, 2019 2:42 pm

lader wrote:
Code: Select all
= INT(($C$4-2)/7) - INT(($C$3-2)/7) + (MOD($C$4-2; 7)>=$C$5) + (MOD($C$3-2; 7)<=$C$5) - 1
C3 - Start date
C4 - End date
C5 - Select number from 0 to 6 for monday, tuesday, etc.

YEP!

Count days in date range

Count days in date range

Re: Count days in date range

Re: Count days in date range

Re: Count days in date range

Re: Count days in date range

Re: Count days in date range