Is it possible to create a table with dynamic dates?

[Rob Horan]

Lets say I want to put together a project plan in Confluence. I create a table with star and end date columns and add a bunch of milestones.

I need the ability to change the date in one place and have that change cascade downstream, dynamically updating any dates that depend on that one.

The date macro is nice but static.

[Katerina Kovriga {Stiltsoft}]

Hi @Rob Horan ,

We can suggest trying our Table Filter and Charts for Confluence app and its Table Transformer macro.

Here is a recent Community thread where I show how to automatically calculate End Dates based on Start Dates and exclude holidays.

Hope this may help your case.

[Katerina Kovriga {Stiltsoft}]

Hi there,

As this question mentions our Table Filter and Charts for Confluence app, we are happy to introduce its new macro – Table Spreadsheet.

The macro allows you to work with fully functional Excel spreadsheets right in Confluence.

You’ll be able to use cells’ formulas, filters, conditional formatting, etc., create pivot tables and charts from the page view&edit mode.

The Table Spreadsheet macro is available for Cloud and Server/Data Center.

[Bill Bailey]

If you were on server, I would tell you to write a user macro. But on Cloud, you would need to look for a commercial plugin, This one sounds like it might help you: useful-macros-for-confluence-cloud 

[Rob Horan]

That's OK, if you told me to write a macro I'd have about as much of a chance at success as I would performing brain surgery with a spork while blindfolded.

[Bill Bailey]

Which surprisingly exceeds the odds of every having user macros in Cloud! ;-)