Calculate Formula based on values for two dates [Closed]

Report
Posts
1
Registration date
Wednesday May 27, 2015
Status
Member
Last seen
May 27, 2015
-
Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
-
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.

2 replies

Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
139
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
Posts
1870
Registration date
Monday August 16, 2010
Status
Contributor
Last seen
January 22, 2021
139
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.
I am waiting for your answer.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!