Results 1 to 9 of 9

Need formula to calculate days in each month across multiple Start and End dates

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    01-16-2012
    Location
    England
    MS-Off Ver
    MS 365 Version 2501 64-bit
    Posts
    1,465

    Need formula to calculate days in each month across multiple Start and End dates

    Another Senior Moment, I'm afraid!

    Attached has four entries with Start and End dates, some of which span more than one month.

    Can't remember formula to "break and combine" the days between the relevant months to create table as shown in Cols H - J

    (E.g. Row 3 is 24 days between 14/02 - 09/03, 9 of which are in March. Row 5 then has 8 days between 14 - 21/03, so formula needs to identify the March total should be 17 days)

    All suggestions, pointers and solutions received gratefully as ever.

    Ochimus
    .
    Attached Files Attached Files
    Last edited by Ochimus; 10-25-2017 at 07:47 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need to calculate # of days per month between two dates even if end date is blank
    By jimthe5th in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 02-09-2023, 01:31 AM
  2. [SOLVED] Calculate year month and days between two dates
    By Premmadaan in forum Excel General
    Replies: 7
    Last Post: 04-24-2017, 05:38 AM
  3. How to calculate number of days between two dates by month
    By MHayward in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-06-2015, 12:26 PM
  4. [SOLVED] Calculate number of days in a month between two dates
    By schlomo87 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-04-2014, 12:32 AM
  5. Replies: 15
    Last Post: 06-03-2014, 02:08 PM
  6. Date Formula for days of the month, new dates starting on the 2nd of the month.
    By Kenn Jerger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-04-2013, 01:31 AM
  7. [SOLVED] Formula needed to calculate working days in specified month between two dates
    By webfeet2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2013, 02:19 AM

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