Loading
Ozgrid Excel Help & Best Practices Forums

Excel Video Tutorials / Excel Dashboards Reports



Results 1 to 5 of 5

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

  1. #1
    Join Date
    17th September 2010
    Posts
    16

    $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.

    Excel Video Tutorials / Excel Dashboards Reports


  2. #2
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    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.be ==> English articles ==> Excel memes

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

  3. #3
    Join Date
    17th September 2010
    Posts
    16

    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?

    Excel Video Tutorials / Excel Dashboards Reports


  4. #4
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    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.be ==> English articles ==> Excel memes

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

  5. #5
    Join Date
    15th August 2005
    Location
    Mechelen, Belgium
    Posts
    6,062

    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.be ==> English articles ==> Excel memes

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

Thread Information

Users Browsing this Thread

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

Possible Answers

  1. Distribute Days Per Month Between Date Range
    By Tom147 in forum EXCEL HELP
    Replies: 5
    Last Post: May 9th, 2012, 23:35
  2. Replies: 2
    Last Post: October 17th, 2010, 05:16
  3. Elapsed Days as Years, Months and Days
    By excelexperts in forum EXCEL HELP
    Replies: 1
    Last Post: January 19th, 2004, 22:46

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
  •  
porno