For example, if Day Entered in A1 = Monday then update the adjacent cells Tuesday -Sunday and then to Monday again; I can use the fill series to do it as well, but I’m looking for a formula do it for me.
Monday it’s a text and fill works because list of days is on Menu/Tools/Options/LibreOffice Calc/Sort List.
It’s possible to do it with formulas and cell format but there is needed to introduce a true date on the first cell not a text with day name.