ToolsOptionsCalculation check Iteration
enter in A2:
=IF(A1="N",NA(),IF(ISNUMBER(A2),A2,TODAY()))

HTH
--
AP

"-emma-" a écrit dans
le message de news: ...

Hey,

This should be easy but I have been struggling with it for a while
now.

A1 = A Validation List with the options "Y" or "N".
A2 = The date (dd/mm/yyyy) appears ONLY "Y" was imput in A1. When "N"
selected in A1, "N/A" apprears in A2.

Once A2 has been filled it needs to stay the same date and not change
to the current date (Which what I have had to stick with for the time
being :() I have battled with =NOW() and =TODAY() but all auto update
each day which isnt what im after. The N/A is unimportant...all that
really matters is the "Y" activating todays date and staying that days
date.

Mail me for screen shots or futher information if needed.

Any help offered at all would be a great help!

Thanks,

Emma x


--
-emma-
------------------------------------------------------------------------
-emma-'s Profile:
http://www.excelforum.com/member.php...o&userid=36378
View this thread: http://www.excelforum.com/showthread...hreadid=561653