Skip to main content

Date range summation by day

  • March 11, 2019
  • 1 reply
  • 18 views
J

I have entry and exit dates (date range) for volunteers to our project. Each volunteer has a separate record. I need a formula or method to show on a calendar how many volunteers I have on any given day by referencing the entry and exit dates of the volunteers.

    This topic has been closed for replies.

    1 reply

    T
    • Tessa_Lau
    • New Participant
    • August 12, 2021

    I have a similar need. I’m using Airtable to schedule resources on jobs. Each job has a start/end date, and requires some number of resources (robots in our case). I want to make a view that shows me how many resources are needed by day.

    I haven’t figured out how to do this in airtable. I’d be willing to pay for a plugin that visualizes this information – the info is already in my table. Any ideas?

    Terms & ConditionsAccessibility statement