Results 1 to 9 of 9
  1. #1
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Count Days (including start date) (Excel 2000)

    Subtract the earlier day from the later date and add 1.

    Days = (Date2 - Date1) + 1

    Andrew C

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Count Days (including start date) (Excel 2000)

    The only "fancy" suitable function I can think of is NETWORKDAYS(), which is availbale if you have the Analysis ToolPak add-in installed and active. However it is a bit specialist as it does not count weekend dates, or any optional holday dates that may be passed to it. Check it out in Help.

    Andrew C

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count Days (including start date) (Excel 2000)

    Oh well, if you want to get fancy, use the DateDif function (Excel 2000 is the only version in which DateDif is documented in the online help)

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Dublin, Ireland, Republic of
    Posts
    2,697
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Count Days (including start date) (Excel 2000)

    Hans,

    I think that produces the same result as Date2 - Date1, and to have both dates inclusive needs to have +1 included.

    Andrew

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count Days (including start date) (Excel 2000)

    Yes, of course. My reply was facetious - I found it slightly strange to want a "fancy" function to calculate (Date2 - Date1) + 1. Please accept my apologies.

  6. #6
    New Lounger
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Days (including start date) (Excel 2000)

    Apparently, less is more. Just thought I might be missing something. That being said, being a new user to Woody's Lounge, I didn't appreciate the facetious replies and am thus inclined to use this forum for searching only vs. posting.

  7. #7
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Count Days (including start date) (Excel 2000)

    I am very sorry if I offended you. I apologize and I hope that one negative experience will not deter you from using the collective knowledge of the Lounge to your best advantage. The general atmosphere here is friendly and helpful.

  8. #8
    New Lounger
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Count Days (including start date) (Excel 2000)

    Thanks! Already using that, but thought there might be a function.

  9. #9
    New Lounger
    Join Date
    Mar 2003
    Location
    Canada
    Posts
    7
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Count Days (including start date) (Excel 2000)

    Is there a way to count the number of days between 2 dates INCLUDING the first day? i.e. Dec. 31/02 and Jan. 1/03 = 2 days (vs. simply subtracting to get 1 day)

Posting Permissions

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