What formula can i use to get the count of items that the due date is greater than the current date?

Brandon Morales · 08/31/23

I tried this but got back #unparseable.

JamesB · 08/31/23

A Countif formula should get the information you need.

=COUNTIF({Facilities Work Requests Range 1},>Today())

This Range {Facilities Work Requests Range 1} should be the Due date column

JamesB · 08/31/23

A Countif formula should get the information you need.

=COUNTIF({Facilities Work Requests Range 1},>Today())

This Range {Facilities Work Requests Range 1} should be the Due date column

Brandon Morales · 09/01/23

PERFECT. that did the trick- Thanks!

JamesB · 09/01/23

Your Welcome

Best Answer