Skip to main content

Count number of days in a date column

  • February 22, 2023
  • 1 reply
  • 29 views
D
Forum|alt.badge.img

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

nefiger
Forum|alt.badge.img+4
  • nefiger
  • Participating Frequently
  • 9 replies
  • February 22, 2023

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.


Terms & ConditionsAccessibility statement