I am looking for a DATE FORMULA that would calculate the last 12 months return of a series of monthly data.
I've tried to nest a date function into a FVSCHEDULE function, but it did NOT worked very well.
I am not very good with DATE calculations, so your help would be very welcomed.
I've attached a simplified sample below.
Thx in advance,