Hi Emma
No probs.
Insert in G2
=TEXT($Y2,"mmm")
in cell H2
=IF(DATE(YEAR($Y2),MONTH($Y2)+COLUMN(A1),1)<$Z2,
TEXT(DATE(YEAR($Y2),MONTH($Y2)+COLUMN(A1),1),"mmm"),"")
Drag across through I2:R2
Select G2:H2 down the page, by just double clicking on the fill handle
at the bottom right of H2 after you have selected.
COLUMN(A1) returns the number 1 (because it is the first column). The 1
as part of A1 has no affect at all.
As you copy across, it will change to COLUMN(B1), C1 etc. and return 2
through to 12.
That number is adding to the Month value from cell Y2 to create a new
date, the final 1 in the formula is making the date the 1st of each
month.
MONTH($Y2) will return the month number for that date, YEAR($Y2)
returns the Year number
Date, takes 3 parameters
DATE(year,month,day)
so DATE(2007,1,1) returns 01 Jan 2007 and
TEXT(DATE(2007,1,1),"mmm") will return Jan. If we used "mmmm" it would
return January.
Hopefully it will be a little clearer now as to how it all fits together