View Single Post
  #1   Report Post  
stormsailor
 
Posts: n/a
Default 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?