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

Topic Labels: Formulas
570 2
Showing results for 
Search instead for 
Did you mean: 
6 - Interface Innovator
6 - Interface Innovator

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!

2 Replies 2

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.

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

Screenshot 2023-07-04 at 6.25.00 PM.png

Screenshot 2023-07-04 at 6.25.09 PM.png