Using a VBA Macro Function might work, check out this sitehttp://stackoverflow.com/questions/9311973/automatic-date-update-in-a-cell-when-another-cells-value-changes-as-calculated