Thread: 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

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

Code:

D3:
=REPT("Yes",AND(($A$2-DAY($A$2)+1)<=D$2,$A$3>=D$2)))
copied across to O3

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