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

On Thu, 17 Jan 2008 18:23:01 -0800, aeddave
wrote:

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.

There is a non-VBA method described he

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

--
Biff
Microsoft Excel MVP


"aeddave" wrote in message
...
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.