+ Reply to Thread
Results 1 to 4 of 4

difference between dates

  1. #1
    Registered User
    Join Date
    05-14-2006
    Posts
    2

    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.

  2. #2
    Biff
    Guest

    Re: difference between dates

    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" <dcccgoose.27s7va_1147584000.6963@excelforum-nospam.com> wrote
    in message news:dcccgoose.27s7va_1147584000.6963@excelforum-nospam.com...
    >
    > 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
    >




  3. #3
    Registered User
    Join Date
    05-14-2006
    Posts
    2
    That worked!!

    Thank you so much!

  4. #4
    Biff
    Guest

    Re: difference between dates

    You're welcome. Thanks for the feedback!

    Biff

    "dcccgoose" <dcccgoose.27tn9d_1147650603.979@excelforum-nospam.com> wrote in
    message news:dcccgoose.27tn9d_1147650603.979@excelforum-nospam.com...
    >
    > 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
    >




+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1