Assign a date

[aeddave]

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.

 

[Gord Dibben]

And where would that date be entered? Adjacent to the dropdown cell? On
another worksheet?

Do you want that date to be static?

If so, VBA event code would be the way to go.

Otherwise a formula using TODAY() function should suffice.


Gord Dibben MS Excel MVP

 

[T. Valko]

There is a non-VBA method described here:

http://www.mcgimpsey.com/excel/timestamp.html