Counting Due This Week

I am trying to count anything that is due this week. I have a due date column in my smartsheet, but what is the best way to count this information?

 

Tags:

Comments

  • Try a formula like this where I assume your date column is called DueDate  - 

    =COUNTIFS([DueDate]1:[DueDate]99,">="&[WeekDate]$1,[DueDate]1:[DueDate]99,"<="&[Weekdate]$2)

    Populate 2 cells in the sheet in a column called Weekdate with the "start of the week" and "end of the week" dates.

    Hope this helps.

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!