+ Reply to Thread
Results 1 to 5 of 5

Count Difference between two dates

  1. #1
    Forum Contributor
    Join Date
    01-25-2005
    Location
    Cardiff, Wales
    MS-Off Ver
    2007
    Posts
    107

    Count Difference between two dates

    Hi all,

    Can someone please help.

    I can't work out how to get a formula to work out the difference in days between two dates.

    e.g. 12/10/2006 and 14/10/2006 = 2 days

    please help.

  2. #2
    Registered User
    Join Date
    01-11-2006
    Posts
    15
    Hi, here what you can do.

    Step 1: Go to Tools-->Add-ins (check on Analysis ToolPack-VBA) --> click OK

    Step 2: Keyed in =NETWORKDAYS(B1,A1) on Row 1 Column C


    Quote Originally Posted by Clash
    Hi all,

    Can someone please help.

    I can't work out how to get a formula to work out the difference in days between two dates.

    e.g. 12/10/2006 and 14/10/2006 = 2 days

    please help.

  3. #3
    Registered User
    Join Date
    01-11-2006
    Posts
    15
    Hi, here is what you can do.

    Step 1: Go to Tools-->Add-ins (check on Analysis ToolPack-VBA) --> click OK

    Step 2: Keyed in =NETWORKDAYS(B1,A1) on Col C Row 1
    For e.g. Col A Row 1 is 12/10/2006
    Col B Row 1 is 14/10/2006
    Type =NETWORKDAYS(B1,A1) in Col C Row 1
    You will get the answer 2 days

    Note: Remember to format cell to number for Col C Row 1

    Quote Originally Posted by Clash
    Hi all,

    Can someone please help.

    I can't work out how to get a formula to work out the difference in days between two dates.

    e.g. 12/10/2006 and 14/10/2006 = 2 days

    please help.

  4. #4
    Niek Otten
    Guest

    Re: Count Difference between two dates

    =A1-A2

    Format as General, not as date (which is what Excel does automatically)

    --
    Kind regards,

    Niek Otten

    "Clash" <Clash.2783by_1146645002.3104@excelforum-nospam.com> wrote in message
    news:Clash.2783by_1146645002.3104@excelforum-nospam.com...
    |
    | Hi all,
    |
    | Can someone please help.
    |
    | I can't work out how to get a formula to work out the difference in
    | days between two dates.
    |
    | e.g. 12/10/2006 and 14/10/2006 = 2 days
    |
    | please help.
    |
    |
    | --
    | Clash
    | ------------------------------------------------------------------------
    | Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
    | View this thread: http://www.excelforum.com/showthread...hreadid=538351
    |



  5. #5
    Stefi
    Guest

    RE: Count Difference between two dates

    Just =Cell2-Cell1
    but format the result cell as General!
    Regards
    Stefi


    „Clash” ezt *rta:

    >
    > Hi all,
    >
    > Can someone please help.
    >
    > I can't work out how to get a formula to work out the difference in
    > days between two dates.
    >
    > e.g. 12/10/2006 and 14/10/2006 = 2 days
    >
    > please help.
    >
    >
    > --
    > Clash
    > ------------------------------------------------------------------------
    > Clash's Profile: http://www.excelforum.com/member.php...o&userid=18951
    > View this thread: http://www.excelforum.com/showthread...hreadid=538351
    >
    >


+ 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