Hi

Try changing the NOW in the formula to TODAY

HTH
--
If this posting was helpful, please click on the Yes button below

Thank You

cheers, francis









"FirstVette52" wrote:

Hey and thanks in advance

I need to insert the current date and time into a cell (that will not update
again) IF another cell is not empty:

IF(C30,NOW()," ")

However, this formula allows the date and time to update each time the
workbook functions update. I need the date to be fixed.

Thx!
--
FirstVette52