Hi.
I have a column where the values are "yes" or "no" in each cell. It is "no" as default and i was wondering if there was a way that when changed to "Yes" the cell next to it which contains TODAY() function can be set to the value it is currently at.

I.e
A B
1 No TODAY()


When yes is selected from a drop down list the today is fixed as the date it was:

A B
1 Yes 20/06/2011
i guess it could be done with macros but i can work out how to get it working.
Thanks in advance.