Get LastModified date

A tip from TechRepublic on how to get the full Path and Filename into an excel footer has been very helpful to me. Now I have tried to find a way to get the date last modified into footer or even into a cell and cannot find a way. Has anyone done that?