I have a list of historical stock prices and their corresponding dates and I am trying to calculate quarterly returns. To calculate this I am trying to use a vlookup where the lookup value is = Vlookup(year,month +1,0),.... to return the last day of the month that starts and ends the quarter.
The problem is that there is no data in there for weekends so if the last day of a trading month is 8/29/09, then it returns an #N/A
Anyone have any ideas on how to overcome this? It would be nice if I could have it look up the max day in that given month, but I dont know if this is possible.
Thanks,
MBO
The problem is that there is no data in there for weekends so if the last day of a trading month is 8/29/09, then it returns an #N/A
Anyone have any ideas on how to overcome this? It would be nice if I could have it look up the max day in that given month, but I dont know if this is possible.
Thanks,
MBO