Long story short I feel off my exercise regimen.
Sooooo, I wanted to recalibrate my spreadsheet to new lower plateau and then increment every sunday by 500 steps.
Being lazy, last time I did it by hand.
Being not so lazy and on hold for a support chat, I refigured the Excel formulas to do it.
=WEEKDAY(A2) gives you 1 for Sunday.
=IF(WEEKDAY(A3)=1,B2+500,B2) did what I wanted it to do.
So the final result to insert and copy down was:
It was easier than being lazy.
# – # – # – # – #