Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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????
my solution: addmonths(NNAV_StartDate, -12)
Start_New ={">$(=date(AddMonths(Max(Start_New),-12), 'MMM-YY'))"}
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'))')
hi
do you try this is set analysis
my solution: addmonths(NNAV_StartDate, -12)