Is there a way (preferably not with VBA) to assign a date to a new record
when a cell is a certain value? In this instance, when a particular cell
shows "Closed/Won/Lost" (selected from a drop down) I want to assign a date
automatically.

Thanks in advance.