ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Static dates in Header (https://www.excelbanter.com/excel-discussion-misc-queries/17532-static-dates-header.html)

bradsdad25

Static dates in Header
 
I use &[Date} and function in my Excel 2003 headers. I would like this date
to automatically update only when I have made edits to the document, not
every time I open it. Also, I would like to have a way of having the previous
saved date show up and be updated on the change. Something like this if
possible.

&[Date] - only changes if there are updates
Previously saved - (date) - have this updated when changes are made

I'm sure one of you Gurus will have an idea that will work. Thanks.


All times are GMT +1. The time now is 12:27 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com