What is the dynamic date formula to update based off a week worth of data?

I'm creating a dashboard for my department using a calculation sheet that pulls data from another sheet. While I've managed to come up with the basic calculations I need, I'm not sure how to make them dynamic so the dashboard displays data for the week (Sunday - Saturday). I don't want to have to manually change things from week to week if possible. Mind you, I'm not that great with formulas.

I'm using the following formula for once of my totals which refers back to a data sheet. In that same sheet, I have a created date column. What should the formula be?

=COUNTIF({Gate Check-in Coke Range}, 1)


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!