Difference between 2 dates - how to?

Hi All,

we have Reporting plugin which enables to calculate the difference between two dates. Do you know how to achieve this? We don't find any docs for this.

We need the difference in days or month.

Thanks in advance,


2 answers

If you are planning to write a plugin to do this, then you can have that plugin have a macro in it that takes two dates as parameters and calculates their difference. To calculate this difference , you can use the Joda API that already comes bundled within the confluence plugin package. More about this here : http://www.joda.org/joda-time/


For any calculations in Confluence, including calculations over tables, you may use CelesteCS Math for Confluence. There are versions for both Confluence Server and Confluence Cloud.

Assume you have a table with three rows and four columns: A till D with two rows and want to summarize elements from B2 to D2. Then here is the formula you should specify in A2:


If you want to calculate average value, use AVG function:


As you see, it is very simple and is similar to EXCEL with equal set of functions.

There is a plenty of other functions in the macro, so you may perform any calculations using formulas in EXCEL style.


Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

1,363 views 97 8
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you