# Calculate Formula based on values for two dates

Closed
srsubs Posts 1 Registration date Wednesday May 27, 2015 Status Member Last seen May 27, 2015 - May 27, 2015 at 05:54 AM
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 - Jun 3, 2015 at 10:49 AM
Hello,

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.

Thanks very much.

Related:

## 2 responses

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
May 27, 2015 at 09:33 AM
srsubs, good morning.

If you have a table like you described, use of a VLOOKUP function is perfect.

You can use too a combination of INDEX + MATCH functions to do this job.

Is this waht you want?
I hope it helps.
Thanks Mazzaropi -- yes those are the functions I would combine -- the trick is in knowing how to use them correctly. I had hoped someone had already done this, but no worries, am making progress. Appreciate your taking the time to write.

Regards...Sam
Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Jun 3, 2015 at 10:49 AM
Sam, good morning.

If you explain your real question a little better, it will be much easier to help you in a concrete and conclusive way.

Is your doubt about the use of VLOOKUP or INDEX + MATCH or how to obtain a past dates?

Here is a place where all particpantes wish to help others.