Macro to calculate correlation from a table but starts from most recent date

Hello pros,

I need a macro that calculates the correlation of my shares of all the columns (except date). However, i want to start calculating the correlation of these shares from the most recent date. For example, I have 5 columns, with 5 different investments. These investments start at different dates, so the shares start at different dates. I want to start calculating the correlation from the most recent share start until the last date (today).

I have a workbook that will make it much clearer to understand..

In this workbook, the oldest share starts 29/12/2003. What i want to do is to start calculating the correlation of all shares (all columns) from the most recent date, which is 22/03/2010.

Please Help! Thanks!