Formula to check if a date is between 2 dates

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.

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

This topic was automatically closed 2 days after the last reply. New replies are no longer allowed.