Inserting a date based on results in another cell.

Hi.

I want a cell to display the date (static, not updated) if the adjacent cell has certain conditions.

In A1 there will be 'Yes' or 'No' chosen by the user. If they choose 'Yes', I want A2 to display the current date and for it NOT to be updated.
If they chose 'No'. A2 to remain blank.

Something like this:

=IF(A1="Yes",DATE,"")

Any ideas?

Thanks in advance.

Silverfern.

Special-K

Thanks for getting back to me. But the way I understand it, the TODAY function is not a date stamp. I will open the spreadsheet tomorrow and it'll have tomorrow's date in there. Excel 2010 Bible by John Walkenback states: "It's important to understand the TODAY function is not a date stamp. The function is updated whenever the work sheet is calculated."

Obviously I won't know if I understand this correctly until tomorrow. Replacing TODAY with DATE does not solve the issue either.

Your thoughts?

Cheers.

Silverfern.

Tony

Again, thanks very much for the info. But this formula will produce a date stamp if anything is entered into the cell. Not specific text. I want it date stamped if 'Yes' is entered and left blank if anything else is entered or it's blank.

I do not understand why this does not work:

=If(A1="Yes",Now(),"")

It fits the layout (Logical Test, Value if True, Value if False) which is how the formula Special-K suggested works.

I have tinkered with the formula and tried: =IF(A1="Yes","",IF(B1="",NOW(),B1)) but that does not work either.....

Getting closer though.

Morning

I would like to try the event macro but have no idea on the appropriate procedure. I know how to get to the VBA editor, and that's about it. The link you provided states the procedure should be self explanatory. It is assuming an higher level of knowledge than I have.

If you have the time I'd like to learn this.

Further details of what I need are:

In range E5:E100, if "Yes" entered, date stamp corresponding cell in column F.
Blank or "NO" should result in no date stamp.
There are 4 sheets within the workbook this is required for.
Workbook attached for clarity.

Yaaaheeeyyy!

It works! Brilliant, and easy once you know how.

No questions thanks. I see where the qualifier 'Yes' has been entered and I had figured out the range input and date adjustments. I'll keep this as I might be able to use this again. I can see I'm going to have to go on a VB course maybe.

Thanks to you ChemistB and thanks to Tony. (Reputation added to both)

Cheers.