+ Reply to Thread
Results 1 to 4 of 4

Counting the number of days in each month across two date ranges

  1. 03-28-2019, 06:12 PM #1
    ScottDAndersen
    ScottDAndersen is offline
    Registered User
    Join Date
    02-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    19

    Counting the number of days in each month across two date ranges

    Capture.JPG

    I need help with the formulas over in cells Q2:S4. I cant figure out how to get it work. I found out a way to do it across months, but not across years too! I appreciate any/all feedback you can provide
    Reply With QuoteRegister To Reply
  2. 03-28-2019, 06:42 PM #2
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Counting the number of days in each month across two date ranges

    Please try this formula in Q2. Fill down and across.
    Formula: copy to clipboard 
    Please Login or Register  to view this content.

    K
    L
    M
    N
    O
    P
    Q
    R
    S
    1
    CHECK IN DATE
    CHECK OUT DATE
    Dec-18
    Jan-19
    Feb-19
    2
    12/1/2018
    1/5/2019
    31
    4
    0
    3
    1/2/2019
    1/3/2019
    0
    1
    0
    4
    1/20/2019
    2/10/2019
    0
    12
    9
    Dave
    Reply With QuoteRegister To Reply
  3. 03-28-2019, 06:43 PM #3
    ScottDAndersen
    ScottDAndersen is offline
    Registered User
    Join Date
    02-01-2013
    Location
    United States
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Counting the number of days in each month across two date ranges

    Holy cow! That worked like a champ. THANK YOU SO MUCH!! now i just gotta figure out what its doing. Thanks again.
    Reply With QuoteRegister To Reply
  4. 03-28-2019, 07:05 PM #4
    FlameRetired
    FlameRetired is offline
    Forum Moderator
    Join Date
    01-21-2014
    Location
    St. Joseph, Illinois U.S.A.
    MS-Off Ver
    Office 365 v 2403
    Posts
    13,406

    Re: Counting the number of days in each month across two date ranges

    You are welcome.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] counting number of days in overlapping date ranges
    By afgi in forum Excel General
    Replies: 11
    Last Post: 07-18-2018, 03:02 PM
  2. [SOLVED] Count the number of days in the year to date less the days in the current month
    By Excelski in forum Excel General
    Replies: 16
    Last Post: 08-22-2017, 11:20 AM
  3. Counting days per month in a date range
    By earjon in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-28-2016, 04:01 PM
  4. [SOLVED] Counting the days of the month referring to a date
    By akbar in forum Excel General
    Replies: 3
    Last Post: 08-19-2014, 04:11 AM
  5. Selecting Between Two Date Ranges (based on days in month)
    By dawsexcel in forum Excel General
    Replies: 3
    Last Post: 07-08-2014, 11:49 AM
  6. [SOLVED] Counting the number of days per month where where a job start time was after 10:00
    By Apache_sim in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-15-2013, 07:59 AM
  7. [SOLVED] Counting Days within multiple date ranges
    By cweideman in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 03-19-2013, 11:07 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1