It's worth noting that the "best" solution here depends greatly on if you are guaranteed to have exactly 1 row for every single day with no "gaps" or whether you may have multiple rows per day and/or gaps in the date ranges.
Given the name of the table, it sounds like this is a completely reasonable assumption.
Drew
Normally I wouldn't disagree but I've seen plenty of "daily" tables where the "oh, well we don't sell on Sundays/Bank Holidays/Xmas so they're blank" rules apply. It's always worth being clear on the assumptions being made.
this is a perpetual soda production machine. every day has a production value.