Counting Due This Week

bmcmichael48661

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?

 

Gopikrishna Mamidipudi

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.