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

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

Tags:

Answers

  • 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!