Try a formula in the destination cell like

=IF(A1="no",TODAY(),"")


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"sunderland27" wrote in
message
...
i want to be able to have the current date populate a field when
another
field is select "no". can anyone help?