Formula

[Steved]

Hello from Steved

1=IF(MONTH(StartDate+ColNum+0*RowNum)=MONTH
($A$1),StartDate+ColNum+0*RowNum,"")

2=TEXT(G4, "d")

both the above give a day number ie 1
The first formula will not work but number 2 does.
What do I need to do to get it to function.
below is the formula No 1 won't, No 2 will
=INDEX($A$1:$C$217,SMALL(IF($B$1:$B$217=$G$3,ROW
($B$1:$B$217)-ROW($B$1)+0,ROW($B$217)+1), $G$5),3)