In order to populate your "Current Date" field you can use:

=IF(Sheet1!T1 = "Y", NOW(),"")

I do not understand the rest.

Thanks,
Roger



"Roxanne" wrote:

I have an excel spreadsheet containing the following sells that are in
questions. I would like to input a formula that will calculate the DOM (Days
on Market) based on

1. Status = Active (Y)

2. If Active, Input Today's Date under the "Current Date" Column

I would only like to manually input the active and the list date cells.

Column T = Active

Column U = List Date

Column V = Current Date

Column W - DOM

ACTIVE

LIST DATE

CURRENT DATE

DOM

Y

10/24/07

N

09/01/07

Hopes this makes sense. What formula would I use in the current date section
for active = Yes and No to remain at the last calculated date? Is it
possible?