Excel - date comparison

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

Guest

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
 
Thanks, Raj. That worked. My night is saved.

Raj said:
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
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using Dates with true and false statements 7
conditional formatting date and blank cell 3
Help with dates 6
Dates in Excel 2007 5
Multiple conditions 2
Excel High lightng dates in future, today and past 1
Comparing Dates 4
Date calculation cell became #NAME?. 1

Back
Top