Automatically insert a STATIC date/time if data in adjacent cell

Hi,
I run a shared spreadsheet for our staff at work. The currently enter their initials in column A, date in column B, and time in column C (and I know you can put date/time in a single cell but we don't want that).

Is there a way to get a formula in column B if the adjacent cell in column A has anything at all entered into it.

I can get it to insert a live date or time by using:

=IF(A1<>"",NOW(),"")

But really need to get it to insert a static date or time that doesn't update itself. Is it possible?

Thanks
Scott

Hi,

With an event macro ...

Please Login or Register  to view this content.