Help

Return days in months based on start/end date

Topic Labels: Integrations
842 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Martin_Hoeedhol
4 - Data Explorer
4 - Data Explorer

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?

0 Replies 0