I am in the process of changing everything from excel/sheets over to Airtable and I have run into a strange problem that is quite trivial in Excel/Sheets but seemingly difficult in Airtable.
Essentially all I want to do is count how many times an email address has come up in the last 30 days from a DATETIME.
Each record has a unique datetime and an email address, all I’m trying to do is count how many times that is happening in Airtable.
The function in sheets is
Where A is the email column, and B is the date of entry.
Any help would be appreciated.