Skip to main content

Count number of days in a date column

  • February 22, 2023
  • 1 reply
  • 42 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

 

This topic has been closed for replies.

1 reply

nefiger
Forum|alt.badge.img+4
  • nefiger
  • Participating Frequently
  • 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