Results 1 to 3 of 3

Months that occur between two dates

Threaded View

  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.

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