EXCEL: Updating my steps target sheet

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:

Taaaa Dahhhh

=IF(WEEKDAY(A120)=1,B119+500,B119)

It was easier than being lazy.

# – # – # – # – #