How to Count How Many Records in A Date Field are Today

[Jeffrey_Brian]

Hey Everyone,

Trying to create a formula that counts how many records in a date field are todays date, let me know if you know how to do this.

I am totally fine if let's say there are 10 records and 4 of them are todays date and the formula counting the ones with todays date just says "4" next to all of the ones that are today - I don't need it to be like chronological as in the first one saying "1" the second one saying "2", etc.

Thank you for any help, greatly appreciate it!

[kuovonne]

In Airtable, a formula field cannot reference other records. So you cannot do this in a formula field.

However, you can create a filtered view that shows only records for the current day, and then you can look at the record count in the summary bar.

[TheTimeSavingCo]

If you needed to access that number for automations, reports, etc, you could also try doing this by linking all your records to a single record in another table and using a conditional Count field