Enter a Static Date through a Formula

[kldesber]

I am trying to create a formula that enters a static date if another cell contains data. I am using an =If function, and do not want to nest the =Now or =Today functions because they automatically update.

I hope someone can help!

Thanks,
Karen

 

[Andrew Poulsom]

Welcome to the Board.

Maybe you can use this:

http://www.mrexcel.com/board2/viewtopic.php?t=184820