JIRA Xporter Template - Calculate a date 180 days before a JIRA Start Date field

[Kurt Willrich]

Hi All,

  I am creating an Xporter Excel Template.  I have pulled the data from the Start Date field using the ${Start Date} format and would like to project a date 180 days before the start date.  What would be the best way to do that using the JIRA script/Java?  Thanks!

[Kurt Willrich]

So I've been able to use a formula and conditional formatting inherent to Excel to get the result I was looking for.  I was able conditionally format the cells and use a formula in the template, which carried over to the exported information, so while I don't have an actual script to pull the information, I was able to find another solution.