Automatically adding dates to a marketing calendar template

AFader

I'm using the social media marketing calendar template. It has months, weeks and days nested, parent/child. Each day can have multiple lines under it for different posts. I would like to be able to tell it That the first Wednesday in January is Jan 1 2025 and have a formula add the correct date to each of the days in the rest of the year. Is there any way to do this?

Paul Newcome

Are you able to provide a screenshot for context?

AFader

Paul Newcome

Are you wanting a separate date type column then that you can enter the first day of the year in and have the rest of the days populate the correct date in this new column?

AFader

I think that would work. As you can see each day of the week has different number of child lines under them so I can't just have it add one to every line. If I can at least get the date in the day of the week row then I can work it out from there, or if it can add the date to every child of the day.