Recurring Dates

Dreim

I am trying to pull data into calendar view where a task or individual repeats every 3 weeks or 21 days. I have the task for a specific date (ie: December 13, 2024) with a formula of (=[ADR Date]@row + 21) that populates the new date into a new column. I repeat this process for the full year using new columns for each date+21.

How do I get to have each task showing in calendar view. Right now I can only see the most current date.

Is there an easier way to do this?

Paul Newcome

For calendar view, each different date needs to be on its own row.

Dreim

@Paul Newcome. Thanks, do formula's work for rows or just each column.

Paul Newcome

I'm not sure I understand what you're asking.

Dreim

@Paul Newcome I can automatically add 21 days to a specific date for each column.

If you are saying that the dates need to be on each row for a calendar, is there a way to populate date+21 on each row automatically?