Static Timestamp without using Macros

[Guest]

Hi,

Is there a way not to use macros (because our network administrator won't
allow macros) if i need static timestamps once a cell is populated? Is there
a formula to tell Excel to perform certain keystrokes like "Ctrl+;" or
"Ctrl+shift+;"?

Thanks,

Maeglin

 

[Guest]

Network administrators do that because they can! One way.

Say your target cell is A1 and to want a static time stamp in B1, put this
formula in B1:-

=IF(A1="","",IF(B1="",NOW(),B1))

Then Tools|options|calculation and check the iterations checkbox.

When A1 is populated B1 will display a static date.

Mike

 

[Guest]

Thanks, Mike H! Worked perfectly!

Network administrators do that because they can! One way.

Say your target cell is A1 and to want a static time stamp in B1, put this
formula in B1:-

=IF(A1="","",IF(B1="",NOW(),B1))

Then Tools|options|calculation and check the iterations checkbox.

When A1 is populated B1 will display a static date.

Mike