Formula to check if a date is between 2 dates

[Kleffi]

Hi, I am facing the following challenge:

I have data records with a start date and an end date.

Now I have many columns with consecutive dates and I want to check in each column whether the date of the column is within the start and end date. If so, a 1 should be output.

I don’t need the number of days between the dates per data record, but the sum of the data records that are there on a certain date.

[rdb]

You can use the if()/ifs() functions to run the check. Then use a sum function to add the 1s up.