I have rows of tasks in Google Sheets - some that will repeat weekly and others that repeat monthly. I want to predict the next year of tasks, but can't seem to merge the weekly/monthly pattern without running into issues.
I realize can do this manually (i.e. copy/paste them each separately, then sort by date) but want a way to do this programmatically, so as I add new tasks, they fall in line without having to redo the manual process.
I have tried a few things with
query and with
arrayformula but can't seem to get either to extrapolate future dates.