Auto-update dates every week with script or formula?

[Daronmal]

I need to track weekly transactions, I already have a way to reset the user inputs at the end of the week, but I need a way to auto update the dates, it could be done manually but it's a bunch of dates to remember to all change at once and could make a lot of issues if they're not updated.

I couldn't really find any basic formulas or commands doing exact what I wanted or close to it. I plan to just set it on a timer to run at the end of the day Friday every week if it's a script.

[Ugochi Ukpai]

Hello Daronmal,

Can you please share more information on this? Are you trying to change the date on Fridays?

[Maliha Syeda]

Not sure if this is what you're looking for, but I found this to auto update the dates each week. You can put this in one cell & then just use the cell reference + 1 for the rest of the days of the week, it's been working well. What I don't have is a way to reset the schedule at the end of the week so if you're able to help with that, it would be appreciated! 

=if(WEEKDAY(today(),2)=7,today(),today()-WEEKDAY(today(),2))