Function for 3 date columns
 

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

Function for 3 date columns
 

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

"Teatro" wrote in message
...
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

Function for 3 date columns
 

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

Function for 3 date columns
 

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