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!!!