This might be a formula or a macro/VBA - I have a feeling it will be VBA.

I have 5 columns in a sheet; A, D, G, J and M. These cells will be changed every so often. They will contain dates.
So for example cells B3 could contain 1/3/13 and then a few weeks later be changed to number 1/4/13.

I would like a formula/macro/VBA code that will tell me the 'highest' date every time the figure in A, D, G, J and M changes.

So for example A3 is 1/3/13 then it is changed to 1/4/13, so the most recent date is 1/4/13
Then cell E3 is changed to 13/3/13, so the 'highest date' is still 1/4/13 - no change
Then B3 is changed again to 3/5/13, so the new most recent date is 3/5/13 and so on.

Example.xls

I am happy for this to be one code or formula that calculates all cells, or for it to be 5 different codes; one for each cell. This will be over 10,000 rows, so it will need to either work on all rows in the sheet, or allow copying to all rows.

An example is attached and I would appreciate any help.

Thanks in advance.