Hi Emma

Assuming the three cells in which you want the month names to show are
U2, V2 and W2
U2
=TEXT(Y2,"mmm")
V2
=IF(DATE(YEAR($Y2),MONTH($Y2)+COLUMN(A1),1)<$Z2,
TEXT(DATE(YEAR($Y2),MONTH($Y2)+COLUMN(A1),1),"mmm" ),"")
copy across to W2
--
Regards

Roger Govier


"curly_lox" wrote in message
...
Roger this looks really good and on practising it in a new worksheet
it
worked perfectly. I already have this giant spreadsheet up though so
when I
go to put in the formula and change which cells its referring to it
shows a
blank.

The Start Month is in Y2, The End Month is in Z2, and the Text Start
Month
is in U2. I'm guessing that the (1) in the formula is whats throwing
it out
slightly

"Roger Govier" wrote:

Hi Emma

With your start date in A1 and end Date in B1 enter in D1
=TEXT(A1,"mmm")
and in E1
=IF(DATE(YEAR($A1),MONTH($A1)+COLUMN(A1),1)<$B1,
TEXT(DATE(YEAR($A1),MONTH($A1)+COLUMN(A1),1),"mmm" ),"")
copy across through F1:O1

--
Regards

Roger Govier


"curly_lox" wrote in message
...
I really need to find a function/formula which will show me the
NAMES
of
months which fall between 2 dates.

Ie 1/1/2007 to 31/3/2007 should show me Jan, Feb, Mar.

I do not want a count of months between 2 dates but what months
fall
between
the 2 dates.

PLEASE HELP!!!
Emma