Generate dates in rows

[cysiekk99]

How do I generate consecutive dates, starting by date I input and increment it day by day in some rows I select?

[JohnSUN]

How to fill column dates

Enter your first two dates, one week apart, e.g. 2021-03-23 and just below it 2021-03-30. Select both cells and drag down. Alternatively, in a cell, enter your starting date, 2021-03-23. Select that cell and down to where you want to finish or a bit beyond if you have an end date in mind) click Sheet > Fill Cells > Fill Series. In the dialog box that opens check the radio button next to Day enter your End date (if you know one otherwise it will just fill to the end of your selection), in Increm…

Two questions about LibreOffice Calc (document background color, fill with dates)

Hello Peter, This might help you. How to change screen color Look in the Menu under → Tools > Options > LibreOffice > Application Colors How to fill column with dates sequentially Select the cells and set their format to Date (right click and select “Format Cells …” in the context menu) Enter the start date into your first cell (e.g. 17.08.2020) Select the start cell and click (and hold) the bottom right corner of the starting cell and drag it down untill you reached you dest…

In a date column, how do I implement a NEXTDAY function

It ought to be simple Agree. But have you tried it actually? [image description]