Assign a date

  • Thread starter Thread starter aeddave
  • Start date Start date
A

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.
 
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
 
Back
Top