Excel Question

[Roxanne]

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?

 

[Roger Converse]

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

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

I do not understand the rest.

Thanks,
Roger

 

[ilia]

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?

In Column V, starting on row 2 (adjust as necessary) use this:

=IF(LOWER(LEFT($T2))="y",TODAY(),0)

In Column W, starting on row 2 and adjust as necessary:

=IF($V2=0,0,$V2-$U2)