When I want to use a date stamp in a spreadsheet report I always use
simple macro to do it. follow these steps.
1: Just place your "NOW" formula or "=today()" into a protected cel
somewhere away from the report section of your workbook. This will b
used as a reference since it will always update each day (as you hav
discovered)
2: Next click on the "record macro" button on your toolbar.
3: Name your macro and enter a shortcut key in the box provided the
click OK.
4: Select the cell with your "NOW" or "=today()" formula in it, righ
click the mouse and copy it.
5: Move to the cell where you want your date stamp to be and select it
Right click again and "paste special". Select "value" from the list.
6: Stop recording your macro.
You should now have a shortcut key such as ctrl-d (or whatever you se
the macro up with) which will place the current date into the correc
cell every time you press it
