TIME STAMP without VBA

Hello!

I need to develop a formula-based way to create a static time-stamp.

1. Cell A1 will be the triggering event (could be text or a date)
2. Cell B1 should contain the formula.

'=today() and/or =now() won't work due to obvious reasons. It needs to be static.

I know how to do this using VBA, but this needs to be formula driven because macros are not allowed in the workbook. Trusting the associates to do CTRL-; manually is also not an option. It needs to be automatic.

Can anyone help with insight?

Thank you!!!

Not possible without VBA

I remember seeing somewhere that suggests:

Make File->Option->Formulas->Calculation options as Manual

I have not tried, but you could do so and share with us! I'm not familiar the Change on that would cause other inconveniences or not.

Hi ikimashu!!!

Unfortunately settings calculation options as manual would prevent the VLOOKUPs etc from functioning on the sheet. We're dealing with associates that barely know how to use a spreadsheet so i'm trying to make this as dummy-proof as possible. I think JEC was correct. This may be impossible without VBA.