Use: Excel 2013
I have a formula in cell L10 which will enter today's date if “closed” or “canceled” is chosen in cell F10.
Example formula in cell L10: =IF(OR($F10={"Closed","Cancelled"}),TODAY(),"")
Formula works ok, expect: if I open the Excel sheet the next day, that day will be...