|I have been using this for a while:|
=IF(J4="yes", IF(K4="",TODAY(), K4),"")
when "yes" is entered in J4, today's date is inserted in K4. This date persists when spreadsheet is opened on later dates. It uses a circular reference, but worked fine.
For some annoying reason it has now stopped working. Any ideas?
edit: sorry should have mentioned this formula is entered into cell K4.
(Excel 2010 on Windows 7)
message edited by purpletallboy