Help

Count number of days in a date column

715 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.