Copy_Date.ods (11.5 KB)
How do inserts a series of dates into a merged cells.
Row4 is where I need the dates to be. The cells below are “check-off” points.
I need to add the dates for Monday - Saturday, I just want to add as a series input,not to be inputted one date at a time.
Any suggestions?
Thanks,
Click and drag from the bottom right corner of your date (indicated by small round dot in image).
BTW there are some who frown upon merged cells in spreadsheets because of the difficulties they can cause later on
That will not work for it gives the following results in each cell before the merge:
09/09/21 09/10/21 09/11/21 09/12/21 09/13/21 09/14/21 09/15/21 09/16/21 09/17/21 09/18/21 or display as:
That’s why you see 18/09/21 at the end
I should modify my comment to “there are some who frown upon merged cells in spreadsheets because of the the difficulties they can cause immediately” 
.
BTW your file starts at 15/9/21 so plus 3 cells = 18/9/21. But then I am using 7.1.5.2 which @PKG has pointed works OK for filling merged cells.
Not using merged cells in spreadsheets, I didn’t even know it was a problem. I did see that Sheet > Fill Cells > Fill series doesn’t work as expected and thought that was what you were having trouble with. Anyway, happy days again. Cheers, Al
PKG- thanks for the “solutions”, I found out that my version was 6.4 (Linux Mint is a LITTLE behind time). Just now downloaded 7.2.1 and I will upgrade tomorrow and follow up.
I’m among those who “frown” - not only concerning the merging, but even more concerning ambiguous date formats. Use ISO 8601
If you think merging of cell areas is urgently needed, always do it as the last step designing the sheet. Otherwise reasonable filling in formulas and getting references by clicking is too much aggravated. Very special formatting also should never be done before every needed functionality is established.
In the attached example a few merged cell areas wer created this way - in the end.
disask68638SpecialWeekHeadings_1.ods (13.3 KB)
PKG, thank you for that upgrade notice for it made my life so easy. I needed to create a “log file” of when medications was given. I wished Linux Mint would update the applications more often.
Again, thank you.