How to circular update week dates

Math3333 · May 4, 2020, 4:53pm

image description

I would like the dates in column A update automatically, 
when the current date will pass 05/09/20 Sat
So I would like to have on **05/10/20**

05/10/20 Sun
05/11/20 Mon
05/12/20 Tue
05/13/20 Wed
05/14/20 Thu
05/15/20 Fri
05/16/20 Sat

JohnSUN · May 4, 2020, 5:15pm

In top left cell

=TODAY()

All other - something like

=B2+1

And set the appropriate cell formats

Example - UpdateDate.ods

Update For “fixed” week from Sun to Sat use

=TODAY()-WEEKDAY(TODAY())+1

Example - UpdateDateInWeek.ods

Math3333 · May 4, 2020, 5:28pm

@JohnSUN. But I would like to keep the dates unchanged until the new week starts on Sun. The column B does not change.