Count of All Items, where Start Date is less than Today
Hi,
I am trying to get a count of all Task Named: "To Do", where "Start Date" is less than Today's date.
I am using: COUNTIFS(Task Name, "To Do", StartDate, "StartDate < Today()"), for this, I keep getting '0', but I see there are at least 4 tasks meeting this criteria.
Any help if very much appreciated.
Thank you,
Deepthi
Comments
-
There are a couple of issues here.
You should not have the "" around "StartDate < Today()"
The Task Name and StartDate should be ranges such as [Task Name]:[Task Name] and StartDate:StartDate (if the column has a space in it you need to use [])
The critereon for the date should just be <TODAY()
So the code should look like this:
=COUNTIFS([Task Name]:[Task Name],"To Do",StartDate:StartDate, <TODAY())
if you want to restrict to something less than the whole column then use numbers in the range.
✅Did my post help answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!
Help Article Resources
Categories
Check out the Formula Handbook template!