Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Count number of days in a date column

1276 1
cancel
Showing results for 
Search instead for 
Did you mean: 
Delphine
4 - Data Explorer
4 - Data Explorer

Dear Airtable Community, 

I have a board with records organized with date field and category list.

1 - I would like to count the number of days in this record. If 4 records are posted with the same date I want it to count 1.

Ex : 01/01/2022 I have 4 records registered at this date, I would like to return 1 day for those 4 entries.

2 - I would like to get the number of records registered per date, I tried to use Interface to do it but could'nt extract the number of dates Step 1.

Thank you for your help.

Best regards,

Delphine

 

1 Reply 1
nefiger
6 - Interface Innovator
6 - Interface Innovator

I'm not too sure where you'd like the count to display, but grouping your records by date will give you a total count of records per day in your grids.