Ask Your Question

Updating days in a series.

asked 2017-08-04 21:59:55 +0200

inflictedd gravatar image

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.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted

answered 2017-08-04 22:29:21 +0200

m.a.riosv gravatar image

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.

Calculating With Dates and Times

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower


Asked: 2017-08-04 21:59:55 +0200

Seen: 32 times

Last updated: Aug 04 '17