Sum up values by date range for 5 following days

[Daniel123]

hi, I have the following question. I need to sum up values by date range e.g. for each row/date, sum 5 following days (if exists) e.g. for day 2024-01-01 sum up all values between 2024-01-01 and 2024-01-04 (5 days). If some days are missing, that's ok, I need to sum all exisitng days  till day start+4.

In Excel I made simple sum of 5 rows but I need make it by date.

thanks

[PhilipMannering · Accepted solution]

Hi Daniel,

This should do the trick,

See attached.

[Daniel123]

such simple, such brilliant. Thank you so much, you are a Star!!!