Converting the Intraday data to End of the Day (EOD) Data.

Hello Friends

Excel Version : 2010
Attached File name : <Intraday to EOD.xlsx>

I am try to convert the Intraday data to End of the data (EOD) data.

The attached excel file contains two tab's namely 1) date in text format & 2) date in date format. In first tab Date is in Text format and in next tab date is in Date format

Now in both formats i need to do the following in the yellow cells H3:L5.
1) Auto populate the next dates (or if possible all dates)
2) The First time open value for the given date,
3) The maximum value for the given date,
4) The minimum value for the given date,
5) The Last time Close value for the given date.

thanks in advance

thilag

Hi
Please see attached sample solution. The solution is based on the date ranges being static as you will see from the formulae.
Hope this helps.
Good luck.
Tony

Hello ARGK

Thanks for your immediate reply and sorry for my late reply.
We cannot every change the cell ranges in vlookup. Now in the attached file `Intraday to EOD 2.xlsx' everything is automated using formulas.

thanks again for your help.

thilag

Please refer this file <Intraday to EOD3.xlsx>