Thank you for the formula! Worked perfectly.

Tea

"Difficult1" wrote:

Assuming there is only one date, as in your example, I made this formula work:
=IF(E50,E5-D5,F5-D5)

I assumed the 5 and 6 were the row numbers....

"Teatro" wrote:

Here is my issue for dates in Excel (2003).

I have 3 columns with dates for which I want to calculate the number of days
that have elapsed between the date sent and the date received. I am trying to
calculate the the fastest receipt date for items sent.

Col 1 has the date sent.
Col 2 has the date for one method of receipt.
Col 3 has the date for the other method of receipt.

I want the next column to calculate the number of days between Col 1 and
either col 2 or col 3, depending on whether there is a date in the column.
Here is an example of the information. Column G would contain the formula for
the number of days.

D E F G
5 12/21/05 no data 12/28/05 # days
6 12/21/05 1/16/06 no data # days

Thank you for your assistance.
Tea