Ask Your Question
0

Updating days in a series.

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

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
0

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

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

Stats

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

Seen: 31 times

Last updated: Aug 04 '17