difference between dates

  • Thread starter Thread starter dcccgoose
  • Start date Start date
D

dcccgoose

I have 3 colums. Sent, Received and #. Sent and Received are formatted
as dates. I'll call them C5,C6,C7 respectively.

What I want to do is:
If C5 and C6 are blank, leave C7 blank
If C5 has a date but C6 does not enter 0 in C7
If C5 and C6 have dates enter the difference in days between them in
C7

This way if things are sent but not received the record can easily be
found by looking for 0, and when things are sent and received the
difference can be seen.

Is this possible?

Thank you.
 
Hi!

Try this:

=IF(COUNT(C5:C6)=2,C6-C5,IF(AND(ISNUMBER(C5),C6=""),0,""))

If sent and received are the same day (if that's even possible) you'll get a
result of 0 which might be confused for a false positive meaning not
received.

Biff
 

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

Transpose between sheets 4
conditional sum? 2
@Need help with a formula 8
Data Entry date/time? 2
data from multiple files: best way to extract 1
Getting rid of +/- in date subtraction.. 4
sum if statement 3
Writing Macros in Microsoft Excel 2010 1

Back
Top