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

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..

Please Help! Thanks!