Hi, May I know how can I use the INDEX MATCH and OFFSET formulas to match the date of stock price and stock price for each day before (day -60 to day -1) and after (day+1 to day +60) the earning announcement date.
Please find attached the data set.
Thanks in advance for any assistance you can provide.
Please find attached the data set.
Thanks in advance for any assistance you can provide.