Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Jul 2001
    Location
    Canberra, ACT, Australia
    Posts
    14
    Thanks
    0
    Thanked 0 Times in 0 Posts

    No. of days between two dates (2000/any)

    Hope someone out there can help me puh-lese...what I'm trying to do is put in a formula that calculates the number of months (rounded to two decimal places) between the last day of the current month (I will type in 08/01 - mm/yy format - in a particular cell) and another date in another cell. So I really need to know the month equiv of the days360 formula, and also how to get it to automatically calculate the date of the last day in the current month and use that in the calculation. Hopefully the attached makes sense of my scrawl. Any help gratefully accepted!!
    Attached Files Attached Files

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: No. of days between two dates (2000/any)

    You can get the last day of a month with the date function, by using a zero as the argument for the day. e.g. this gives 30 november:
    =DATE(2001,12,0)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

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

    Re: No. of days between two dates (2000/any)

    If the start date is in A1, and the end date is in B1 see if this will give you what you want:

    <pre>=DATEDIF(DATE(YEAR(A1),MONTH(A1)+1,0),B1,"m") +DAY(B1)/DAY(DATE(YEAR(B1),MONTH(B1)+1,0))
    </pre>

    Legare Coleman

  4. #4
    3 Star Lounger siflaar's Avatar
    Join Date
    Jan 2001
    Location
    Amersfoort, Netherlands
    Posts
    203
    Thanks
    4
    Thanked 0 Times in 0 Posts

    Re: No. of days between two dates (2000/any)

    The last date of the month could be calculated with an Excel function: EOMONTH(date;0)
    Greetings,

    Patrick Schouten
    (The Netherlands)

Posting Permissions

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