CountIF Formula for Dates in the Past
I am trying to amend a current formula I am using to track enrollment. Currently, I have this formula:
=COUNTIF([Date of Injection]1:[Date of Injection]100, ISDATE(@cell)) which counts the amount of cells that have a date so my team can track how many animals we have enrolled in a certain project.
I want to change this to count the number of cells with a date but only if that date is in the past so my sheet summary data accurately reflects current enrollment.
Is this possible?
Help Article Resources
Check out the Formula Handbook template!