hi guys, using libre office calc on windows 11 pro laptop,
I would like to auto add consecutive days, ie col A1 Monday, A2 Tuesday etc.,
I have managed to work out dates, ie (B1 1st june 23, B2 2nd June 23), B1 1/6/23, =B2+1, but that method doesn’t work on the days option
please help, all help and advice appreciated
If you use elements defined in Options → Calc → Sort Lists, then you may put e.g. "Mon" to A1, then drag-copy it down, and have what you want.
But possibly a better way would be using dates, and format your cells to show weekdays?
2 Likes
thank you, much appreciated
In A1, type Monday and press Enter. Use the handle at the bottom right of A1 to drag down as far as you need. You can do the same with dates, numbers, etc.
1 Like
thank you, I appreciate your help and advice