Today() function

[DB]

I have worksheet that uses the =today() fuction as
contents. The spredsheet is saved as a template opened
data entered then saved as a file. Several of these may
be saved in a day. The form is emailed to another office.
If they open it the same day the date is no factor but
if they don't open the file until the next day then the
date cell still relects the current day which should be
in this case the day before.

I want to use an automatic date feature like Today(), but
I need to be able to convert it to a value when the file
is saved. I need to do this automatically in a formula or
other. People using this form are not computer savy. To
manually copy/paste special as value or to run a macro to
do the same is not an option.

Can this be done within a formula or someway
automatically.

Thanks for any help
DB

 

[Andy Brown]

I need to do this automatically in a formula or other ...

People using this form are not computer savy ...
copy/paste special as value or to run a macro to
do the same is not an option.

Because they're not computer-savvy? (Who is?)

AFAI can see, you won't get =TODAY() to act non-volatile. Event code in
ThisWorkbook module, perhaps.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Range("A1") = Date
End Sub

HTH,
Andy

 

[pfsardella]

To enter a date, use Ctrl+;

For more info on dates and times, see this WebPage by David McRitchie.

http://www.mvps.org/dmcritchie/excel/datetime.htm

Search for 'System Date/Time into a Cell or within Code' to find
different ways to enter Time and Date.

HTH
Paul