+ Reply to Thread
Results 1 to 5 of 5

Month between two dates

  1. #1
    Forum Contributor
    Join Date
    11-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    390

    Month between two dates

    Hi,

    How can I get the name of the months between two dates based upon the number of days in the months. for example if dates contain 10 days in January and 20 days in february then I want February to be shown. See below my expectation.

    Start Date End Date Month
    29/06/2016 22/07/2016 July (or the number of the month in year which is 7)
    26/06/2016 01/08/2016 July (or 7)

  2. #2
    Forum Expert shukla.ankur281190's Avatar
    Join Date
    05-17-2014
    Location
    Lucknow, India
    MS-Off Ver
    Office 365
    Posts
    3,935

    Re: Month between two dates

    Row\Col
    A
    B
    C
    1
    29.06.2016
    22.07.2016
    7
    2
    26.06.2016
    01.08.2016
    7


    C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)

  3. #3
    Forum Contributor
    Join Date
    11-09-2012
    Location
    United Kingdom
    MS-Off Ver
    Excel 2013
    Posts
    390

    Re: Month between two dates

    Perfect, Thanks Shukla.
    Quote Originally Posted by shukla.ankur281190 View Post
    Row\Col
    A
    B
    C
    1
    29.06.2016
    22.07.2016
    7
    2
    26.06.2016
    01.08.2016
    7


    C1
    Formula: copy to clipboard
    Please Login or Register  to view this content.

  4. #4
    Forum Guru benishiryo's Avatar
    Join Date
    03-25-2011
    Location
    Singapore
    MS-Off Ver
    Excel 2013
    Posts
    5,147

    Re: Month between two dates

    basing on Shukla's formula, you can get the month name too:
    =TEXT(DATE(2017,MEDIAN(INDEX(MONTH(ROW(INDIRECT(A2&":"&B2))),)),1),"mmmm")

    Thanks, if you have clicked on the * and added our rep.

    If you're satisfied with the answer, click Thread Tools above your first post, select "Mark your thread as Solved".

    "Contentment is not the fulfillment of what you want, but the realization of what you already have."


    Tips & Tutorials I Compiled | How to Get Quick & Good Answers

  5. #5
    Valued Forum Contributor Root_'s Avatar
    Join Date
    07-29-2017
    Location
    _
    MS-Off Ver
    2010+
    Posts
    483

    Re: Month between two dates

    Late to the party, but here are simpler formulas:

    =MONTH((A1+B1)/2)
    =TEXT((A1+B1)/2,"mmmm")

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 1
    Last Post: 07-02-2017, 08:02 PM
  2. [SOLVED] Calculation of days per month for dates beginning in one month and ending in another month
    By Fahrettin in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 04:52 PM
  3. [SOLVED] Renaming Sheets with present month, all dates of that particular month
    By laansesu in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-04-2015, 08:43 AM
  4. [SOLVED] Is there a way to insert all dates for a month weekly when user inputs Month and a Year?
    By uniqbboy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2014, 10:40 AM
  5. find time left in month.days unit between two dates(in YEAR.MONTH.DAY)
    By xcfeng95 in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 02-21-2014, 12:55 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. Replies: 2
    Last Post: 12-01-2012, 03:06 PM

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