+ Reply to Thread
Results 1 to 2 of 2

months between 2 dates!!!

  1. #1
    Registered User
    Join Date
    07-06-2005
    Posts
    15

    Question months between 2 dates!!!

    A few weeks ago I posted a thread asking for a formula to count number of months between 2 dates with partial months counted as whole months.

    Here is what my spreadsheet looked like:

    START END TOTAL
    DATE DATE MONTHS
    1/1/2005 4/29/2005 4

    The formula I used is as follows:

    =IF(I51="","",MONTH(I51)-MONTH(H51)+1)

    Now in actually using the sheet I found that this formula is basically useless when the difference between the 2 dates exceeds a year for example:

    START END TOTAL
    DATE DATE MONTHS
    1/1/2005 4/29/2006 4

    Does anyone know what formula I can enter so that the fact that the total months exceeds a year will be counted as such? In the second example I provided I want it to say 16 months, not 4.

    Any help will be greatly appreciated!

  2. #2
    Registered User
    Join Date
    07-06-2005
    Posts
    15
    I seemed to have figured it out...

    =IF(I51="","",(YEAR(I51)-YEAR(H51))*12+MONTH(I51)-MONTH(H51)+1)

    but if anyone sees why this may not work please let me know...thank you

+ 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