Results 1 to 13 of 13

Calculating Months/Yr including partial months

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2011
    Location
    Rochester, NY
    MS-Off Ver
    Excel 2007
    Posts
    19

    Question Calculating Months/Yr including partial months

    Hello - I am trying to calculate the number of months in between two dates for a given year. The formula needs to take into account partial months as the number of days divided by the number of days in that month so 30 if November, 29 if February on a leap year, etc. The attached spread sheet shows for example what I need. I've been working on this for a while and can't get it right.

    I started with lookups and countif and have a list of all days since January 2004 in a look-up range, but besides not giving me the exact answer there has to be a simpler way than listing all days in a lookup/reference table. Any help would be greatly appreciated!!
    Attached Files Attached Files
    Last edited by run2win17; 02-01-2011 at 02:52 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

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