Forum Discussion
COUNTIF with dates
We have students checking in various dates. I have a column of check-in dates and would like to know how many have checked in as of today. Set a cell (D59) for today's date (=TODAY()) and used =COU...
Hello, markyehl
My understanding of challenge posted here is as follows,
- Student check-in dates are either Past or Today's date.
- Needs to calculate how many total Students are active check in till date.
If my understanding is correct, then formula should be as below, included today function in formula. Also please find attached sample sheet.
Hope this will of help to you.