Difficult sum

In my report, I have a date filter. With this I select one date, for example Dec. 31, 2023.   My source data is structured as follows:   ID Startdate Untildate Value 1 Nov. 1, 2023 Nov...