+ Reply to Thread
Results 1 to 4 of 4

Days in particular month between two dates

  1. #1
    Registered User
    Join Date
    07-07-2008
    Location
    Australia
    Posts
    44

    Days in particular month between two dates

    Hi,

    Attched example, have a start date (col E) & end date (col F) then months Dec-10 through to Jun-12 as columns heading from G-W. Looking for a a formula that will give me the number of days that fall between the start & end date for the month in the column heading, hoping someone can assist.

    Many thanks

    Branno

  2. #2
    Forum Moderator daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,676

    Re: Days in particular month between two dates

    Assuming you include both start and end date in the count try this formula in G2 copied across and down

    =MAX(0,MIN($F2,EOMONTH(G$1,0))-MAX($E2,G$1)+1)
    Audere est facere

  3. #3
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Days in particular month between two dates

    Please test carefully.

    Let you know if this is what you want?
    Notice my main language is not English.

    I appreciate it, if you reply on my solution.

    If you are satisfied with the solution, please mark the question solved.

    You can add reputation by clicking on the star * add reputation.

  4. #4
    Forum Expert
    Join Date
    05-30-2012
    Location
    The Netherlands
    MS-Off Ver
    Excel 2016
    Posts
    13,764

    Re: Days in particular month between two dates

    You marked your question as solved.

    Please respond if this (#3) what you up to.

    Or did you use the solution of daddylonglegs?

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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