Show date 12months prior to start date

[Fig1]

I would like to display the date 12 months prior to the start date.

Start_New =(">$(=AddMonths(Max(Start_New),-12, 'MMM-YY')"))

am i close????

[lironbaram]

Start_New ={">$(=date(AddMonths(Max(Start_New),-12), 'MMM-YY'))"}

[Fig1]

This didnt work.  I have had a bit of play and came up with this, however it is showing the value as 'zero' and not the date.

Start_New=('$(=date(addmonths(max(Start_New),-12), 'DD-MM-YYYY'))')

[lironbaram]

hi

do you try this is set analysis

[Fig1 · Accepted solution]

my solution:  addmonths(NNAV_StartDate, -12)