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
    9

    $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
    5,892

    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, 2012, 2013



    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
    9

    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
    5,892

    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, 2012, 2013



    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
    5,892

    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, 2012, 2013



    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