How to calculate the total amount of events happening between certain days

mrmrgolding · 09/07/22

Hello,

I have a sheet that lists out football games across multiple codes which happen on specific days, the games are happening from Wednesday to Sunday.

I was wondering if there was a formula to calculate the number of events happening each week but only from specific days i.e. Wednesday to Sunday?

Thanks for your help

Brucey · 09/08/22

Hi there,

Have you tried using a COUNTIF(S) formula?

your range1 could be the dates column

criterion1 would be < date

range2 also the date column.

citerion2 would be < date

Answers