Count the number of Occurances of Fri, Sat & Sun

[Mattdaddy1]

Hi All,

I have a start date in C1 and an end date in D1. I need a formula in E1 that tells me the total number of times Fri, Sat & Sun would be in that date span. Keep in mind the dates are user input so they might not always be full 7 day weeks that are entered so I can't just count the number of weeks and multiple by 3. It has to count the actual number of Fridays, Saturdays & Sundays in the date span and return a sum. (i.e. 2 Fridays, 2 Saturdays and 1 Sunday would return "5")

I'm sure this is super simple for someone, that someone is not me.

Thanks in advance.

Matt

 

[theBardd]

This formula

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(C1&":"&D1)))=7))

counts Saturdays, Fridays s , Sundays 1.

 

[theBardd]

This sums for all 3 days

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT($C$1&":"&$D$1)))={1,6,7}))

 

[Mattdaddy1]

This is perfect!!!!!! Thank you so very much!!!

 

[Scott R]

=networkdays.intl(c1, d1, "1111000")

 

[AhoyNC]

Here is another option. The string "1111000" represents Monday - Fri., the 1 is used for days not to count and the 0 for days to count.

Excel Workbook
	C	D
1	4/5/2019	5/8/2019
2
3		15
Sheet