Announcement

Collapse
No announcement yet.

$10 - Determine how many days in elapsed range fell within each month

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • $10 - Determine how many days in elapsed range fell within each month

    Hi, prefer formula over VB.

    1. Calculate # of days between two entered dates, assume 1 date in each column. Easy.

    2. If end date is not within same month as start date, determine how many days elapsed within each month. Head-scratcher....... Elapsed days could be over 2, 3, 4, or more months.

    Formating is flexible, could use separate columns for Jan, Feb, Mar, etc. if that helps.

    Example: 2/20/2012 to 4/5/2012: = 10 days in Feb / 31 days in Mar / 5 days in Apr.

  • #2
    Re: $10 - Determine how many days in elapsed range fell within each month

    Hello Gaallen

    This one has been tackled before. Fellow MVP Chip Pearson wrote a nice article about the subject:
    http://www.cpearson.com/Excel/distribdates.htm

    Including a sample workbook so that copy/paste formulas becomes easy :-)
    http://www.cpearson.com/Zips/SplitDates.ZIP

    Can you please read the article and see whether you can copy the logic to your file?
    Regards,

    Wigi

    Excel MVP 2011-2014

    For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

    -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

    Comment


    • #3
      Re: $10 - Determine how many days in elapsed range fell within each month

      That is perfection, kind sir, and saves me a headache. May I offer you some beer money for your assistance?

      Comment


      • #4
        Re: $10 - Determine how many days in elapsed range fell within each month

        I will send you the PayPal details.
        Regards,

        Wigi

        Excel MVP 2011-2014

        For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

        -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

        Comment


        • #5
          Re: $10 - Determine how many days in elapsed range fell within each month

          Thanks!

          I will not hesitate to buy some beers with it on Friday... European championships soccer will start.
          Though Belgium is not there unfortunately.

          See you,

          Wigi
          Regards,

          Wigi

          Excel MVP 2011-2014

          For more Excel memes: visit http://www.wimgielis.com ==> English articles ==> Excel memes

          -- Topics without [CODE] tags or a meaningful topic title, will be neglected by me (and probably many others as well) --

          Comment

          Working...
          X