Thread: Insert a date that does not update if a condition is true
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
  
Posts: 3,346
Default Insert a date that does not update if a condition is true
Hi,

You will probably have to consider a macro. Do you want to code this?

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"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
Reply With QuoteReply With Quote