Tools>Options>Calculation check Iteration
enter in A2:
=IF(A1="N",NA(),IF(ISNUMBER(A2),A2,TODAY()))
HTH
--
AP
"-emma-" <
[email protected]> a écrit dans
le message de news:
[email protected]...
>
> 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
>
Bookmarks