Complicated Count If Formula (1 Viewer)

[samm.almeida]

Hello all!

I am working as a transaction coordinator in real estate. I need a formula to show how many days a home has been active until the closing date occurs.
I have tried several formulas, but i can't seem to find the right combination to have excel count how many days a home has been active, but stop counting once the closing date has occurred.

 

[Isaac]

Can't you just subtract one date from the other?

It doesn't make sense to ask for formula help if you're not providing the information about what data points you actually have.
How could we possibly suggest a solution? We would just be guessing.

 

[samm.almeida]

Column A: Date a home goes on the market
Column L: Closing date.

I was needing a formula to calculate how many days a home is active before closing. If the home is not under contract, we will not have a closing date entered so I cannot do a subtraction formula. I. need it to continually count until a closing date is entered.

Sorry for the lack of information!

 

[Minty]

Something like

=IF(IsBlank(L2),Days(Now(),A2),0)

Will return 0 if complete or the days up to today if not.

 

[Isaac]

=Date1 - Date2 accomplishes the basic goal. Next use an IF statement for if Date2 is blank, then today() minus Date1.

 

[arnelgp]

=DAYS(IF(ISBLANK(L1),TODAY(),L1),A1)