I'd like some help with calculating a formula that uses values corresponding to specific dates. I have a list of daily dates and a value eg. a stock price, for each date,. I'd like to calculate the difference in price (or investment return) between 2 dates that I specify.
Even better would be a way to calculate the difference for specified periods, eg. For a given date, the difference in value between that date and 1 month ago, 3 months ago, 1 year ago, 3 years ago etc.