Hi, 

I have a table with seasons. To make it simple, two records (without year).

startdate = '01/01 '
enddate = '30/03 '
season = 'High Season'
price = $100

startdate = '24/12 '
enddate = '27/12 '
season = 'Christmas'
price = $150

I now want to check in a formula whether an appointment field falls within a season and what the total price is, eg for an appointment from 24/12/2020 to 03/01/2021.

24/12 = $150
25/12 = $150
26/12 = $150
27/12 = $150
28/12 = $100
29/12 = $100
30/12 = $100
31/12 = $100
01/01 = $100
02/01 = $100
03/01 = $100

total price: $ 1.300

Thanks,Rob