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


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
    Brucey ✭✭✭✭✭

    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

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!