Months that occur between two dates

[timbellamy]

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

[DonkeyOte]

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...)

[timbellamy]

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