Calculating days between two dates where one cell is empty

[Dan012]

Hi everyone' I am trying to calculate the number of days between two dates (a start and an end date) and also where if the end date is left blank it calculates today as the end date.

This is to calculate the number of days on market for a product.

Eg. Cell A5 is the start date, cell B5 is the end date of the event I.e sold. (The end date may not be filled in as yet if the product is not yet sold). Cell C5 is the answer with total number of the products days on the market including if it still for sale e.g 54 days on market.

So I need a formula that will calculate the number of days between A&
B column if they are completed and also assume that cell B5 is today's date if it is left blank.

Any help will be greatly appreciated.

 

[jasonb75]

You will probably get incorrect results when F3 < K1 as well.

Try =MIN($K$1,F3)-MAX(I$1,E3)+1

 

[SaraWitch]

I know this thread is old, but none of these worked for me, so I played around and came up with this:

=IF(A5="","",IF(B5>0,B5-A5,TODAY()-A5))

Just in case anyone else comes looking, this worked for me!