Count of cells in a date range

edited 12/09/19 in Formulas and Functions

Hello, - I am fairly new to Smarsheets and not very knowledgable past basic formulas.  I am trying to create a formula that  will display the count of cells whose date is from Monday through Sunday, each week.  Like how many open items were closed this week. I can't seem to figure out the criteria wording.... 



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!