+ Reply to Thread
Results 1 to 3 of 3

Months that occur between two dates

  1. #1
    Registered User
    Join Date
    01-13-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Cool Months that occur between two dates

    Hello,


    I would like a formula (if it is possible) that will list which months occur between two dates;

    i.e
    Start Date (Cell ref A2) = 01/01/2010 (in the dd/mm/yyy format)
    End Date (A3) = 02/05/2010

    In cells D2:O2 I have the months Jan-Dec.

    In cells D3:O3 I would like a "Yes" to appear if the above month occurs between the dates in A2 & A3

    In this example would like a "Yes" to appear in cells D3, E3, F3, G3 & H3 but not in the other 'Months' appropriate cells.

    Hopefully this is possible?

    Please let me know if you need further clarification on what i mean.

    Cheers
    Last edited by timbellamy; 01-16-2010 at 01:00 PM.

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Months that occur between two dates

    Assuming the "months" in D2 onwards are Date values (eg 1/1/10 etc formatted as mmm-yy etc..) then:

    Please Login or Register  to view this content.
    EDIT: thread moved from Workshop Forum to Worksheet Functions Forum - please try to post in most appropriate forum (hard to decipher at times I would concede...)
    Last edited by DonkeyOte; 01-13-2010 at 10:50 AM.

  3. #3
    Registered User
    Join Date
    01-13-2010
    Location
    Nottingham, England
    MS-Off Ver
    Excel 2003
    Posts
    12

    Re: Months that occur between two dates

    Hi,

    sorry for posting in the wrong forum, will check more next time.

    Thanks for the reply, it works perfectly well, i'd been trying to figure something out for ages all to no availbut this fits great.


    Cheers

+ 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