Re: How to calculate the Maximum price on basis of current selection of a date to previous 52 weeks
you have to devise a way so that, based upon the user's selection of a date, the 52 weeks prior to that (o that.ne year?) are selected. Then the max() function should return the maximum value in that range.
That could be done via a sheet-level trigger that selects, based on the user_selection in the date_field, all the dates starting from one year prior to that.