Function for 3 date columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Hi!

Does "no data" mean the cell is empty or does it literally contain the text
"no data" ?

Will there only be one other date in either column E or F ?

If there may be a total of 3 dates which one do you want to use ?

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

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