Hyperlinked cell date and time

Hi All,


There is a file with 100's of hyperlinked cell in excel, which the link gets updated on a weekly bases from multiple individuals. I was wonders if there is a formula to get the date and time of the update to the hyperlinked cells instead entering the date and time manually.

Hi
Have a look at this link:
http://www.mrexcel.com/forum/excel-q...lications.html
Good luck
Tony

Thanks for your response unfortunately the marco didn’t work for me in the link. Just to be more specific the hyperlinks are not in date format it is just headers of workbooks. Is there any other solution to extract the date and time of the hyperlinked cells?