Need to have the output of Date() to be static

[Arindam1980]

Hi All,

My date output at A40 is dependent upon what's at C40..see below. However, I need to have the date to remain static and not change the next day. Can someone help in getting this done via formula, macro/VB etc? Also, how to extend the same logic to other cells as well?

IF(C40<>"",TODAY(),"")


Would really appreciate any help here?

[sandy666]

try this schema: B2: =IF(A2="","",IF(B2="",NOW(),B2)) change suitable to your conditions. But first turn ON: Option-Formulas-Enable Iterative Calculations = checked
you can use NOW() or TODAY() it's up to you. Without Iterative Calculations enabled you will get warning and it doesn't work.
Or look for VBA solution.

[Arindam1980]

Thanks Sandy!

I am going to wait for the day to change to view the results.

[sandy666]

Ok, let me know if it will work.

[BlindAlley]

If Sandy's code works - great.

If it is not what you are looking for - Here is a VBA solution that puts a static Date Stamp into your chosen cells.

Change the Range and Offset # to match your requirements.

Right click on the sheet tab name choose 'View Code and copy the code into the developer screen on the right.
Your worksheet must have Macros Enabled and be saved as .xlsm and not .xlxs

[BlindAlley]

Oooops - Double post