Count of entries in the last 24 hours
I've got a sheet to record our queries as they come in and I'm looking for a formula to count the number of entries received in the last 24 hours as a running total I can monitor. At the minute I have set it up to count the queries received yesterday as per formula below but I'd be glad of some help how I can amend this if possible?
=COUNTIFS([Date Received]:[Date Received], WORKDAY(TODAY(), -1))
Help Article Resources
Check out the Formula Handbook template!