Check in the attached...
First I compute the max date of the dataset and then for all the months equal to the Max Date month, I compute the sales only for the days lower or equal to the Max Date day. So for every years, for June, only the days 1-7 are used in the Sales computation.
Net Sales Calc ed mc.twbx 39.6 KB
Awesome, thanks Michel!