Excel - date comparison
 

I have 2 columns, "received" and "shipped to customer", in standard date
format. I want to show a third column that shows the number of days in
between. I know I subtract one from the other. However, I also have blanks
in the shipped column for product that has not yet shipped out. For days
between the columns, I want it to treat blank cells as today's date. How do
I do this?

Hi Stormsailor

Try this formulae (assuming received date is in A1 cell and shipped date is
in B1 cell). in C1 where you need the difference try this formulae

=IF(B1="",TODAY()-A1,B1-A1)

This shall suffice your requirement.

Regards,
Raj

"stormsailor" wrote:

I have 2 columns, "received" and "shipped to customer", in standard date
format. I want to show a third column that shows the number of days in
between. I know I subtract one from the other. However, I also have blanks
in the shipped column for product that has not yet shipped out. For days
between the columns, I want it to treat blank cells as today's date. How do
I do this?

Thanks, Raj. That worked. My night is saved.

"Raj" wrote:

Hi Stormsailor

Try this formulae (assuming received date is in A1 cell and shipped date is
in B1 cell). in C1 where you need the difference try this formulae

=IF(B1="",TODAY()-A1,B1-A1)

This shall suffice your requirement.

Regards,
Raj

"stormsailor" wrote:

I have 2 columns, "received" and "shipped to customer", in standard date
format. I want to show a third column that shows the number of days in
between. I know I subtract one from the other. However, I also have blanks
in the shipped column for product that has not yet shipped out. For days
between the columns, I want it to treat blank cells as today's date. How do
I do this?