Return days in months based on start/end date


#1

Hi,
I am using Airtable in combination with Zapier

Zapier generates a record in my master table with a start and end date. Those dates can be 1) within the same month, 2) across two to many months, 3) over a new year.

I would like to log for each record, how many dates are within each month within the given date range.

E.g. 1) 3/5/19 - 3/10/19 should return 5 days in month 3
2) 3/5/19 - 5/2/19 should return 26 says in month 3, 30 days in month 4, 2 days in month 5
3) 12/29/18 - 1/3/19 should return 2 days in month 12 2018, 3 days in month 1 2019

The reason is that I want to calculate occupancy per year/month across multiple master table line items.

Any thoughts?