This was SO easy in Excel. I have a sheet where I HAD a date picker in excel. I clicked the linked cell, a calendar popped up and I double clicked a date to enter it into the linked cell. Here's the question for this post. That date was for the first Monday of any week for a weekly schedule. Cells just to the right of the other days of the week populated with their correct dates. Cell B1 is where the Monday date was entered by selecting the Monday on the calendar date picker. Then cell A9 which had the simple formula B1+1 showed the date for the Tuesday of that week - Monday plus 1 day

Cell A16 had the formula =B1+2 showed the date for the Wednesday of that week - Monday plus 2 days

Cell D2 had the formula =B1+3 showed the date for the Thursday of that week - Monday plus 3 days (two columns, hence the shift over to column D

This obviously does not work in Calc. I've tried formatting the cells as dates Format > Number > Date and selecting a date format. That did not work

I tried selecting the destination cells for each day and using Edit > Fill > Series but Series was greyed out. I suppose because the cells are not adjacent.

I tried selecting a range of cells in a column that WERE adjacent and using the Edit > Fill > Series menu option. The selected cells populated with the dates and they incremented. I thought I was getting close!

But! when I changed the Monday date the cells in the series did not increment again 8-(

So, this is probably simple stuff. I just need some help breaking the excel paradigm - please!