difference between dates

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

"dcccgoose" <[email protected]> wrote
in message news:[email protected]...
>
> 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.
>
>
> --
> dcccgoose
> ------------------------------------------------------------------------
> dcccgoose's Profile:
> http://www.excelforum.com/member.php...o&userid=34416
> View this thread: http://www.excelforum.com/showthread...hreadid=541897
>

That worked!!

Thank you so much!

You're welcome. Thanks for the feedback!

Biff

"dcccgoose" <[email protected]> wrote in
message news:[email protected]...
>
> That worked!!
>
> Thank you so much!
>
>
> --
> dcccgoose
> ------------------------------------------------------------------------
> dcccgoose's Profile:
> http://www.excelforum.com/member.php...o&userid=34416
> View this thread: http://www.excelforum.com/showthread...hreadid=541897
>