Results 1 to 7 of 7
  1. #1
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    days between dates (2000)

    In column A I have listed the months of January through December, 2003, in the format "MMMM-YY". I would like to calculate the number of days between 2 end of month dates, but when I try and use the Datedif function and reference cells a1-a12, I get an error message.
    Any ideas?
    Jeff

  2. #2
    2 Star Lounger
    Join Date
    Jan 2002
    Location
    Trenton, Ontario
    Posts
    175
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: days between dates (2000)

    Are you putting the quotation marks into the formula? The correct formula would be

    =DATEDIF(A1,B1,"d")

  3. #3
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: days between dates (2000)

    Are the values in column A text entries or are they date values formatted as you described? What error message are you getting? What did your DATEDIF function look like?
    Legare Coleman

  4. #4
    Bronze Lounger
    Join Date
    Jan 2001
    Posts
    1,418
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: days between dates (2000)

    Yes, I was/am. I just found my problem: when entering the dates, the earliest date must be first!
    Thanks,
    Jeff

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: days between dates (2000)

    Where is this DateDif function? Both my analysis toolpaks are active and I still can't find it?
    Sorry for this dumb question!
    Regards,
    Rudi

  6. #6
    Platinum Lounger
    Join Date
    Jan 2001
    Posts
    3,788
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: days between dates (2000)

    See DATEDIF Function, in most versions of Excel it is undocumented.

  7. #7
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: days between dates (2000)

    Tx = <img src=/S/blush.gif border=0 alt=blush width=15 height=15>
    Regards,
    Rudi

Posting Permissions

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