Put this formula into A2 & then copy to all your cells
--requires the Analysis Toolpak add-in

=(ROW(A2)-1)*((ROW(A2)-1)<=DAY(EOMONTH(DATEVALUE(A$1&" 1, 2005"),0)))

"Jerry Kinder" wrote:

Col A is Jan, Col B is Feb, etc. to Dec.

in A2 is 1 Jan in B2 is 1 Feb and so on.

I want to drag down from row 2 to 32 but want each month to stop displaying
dates when the end of each Month comes. Jan has 31 days and Feb has 28 so
Feb will display nothing in the last few cells not start with March.

I use =A2+1 in A3 etc. across the top and drag all columns down at one time
so I do not have to do each column one at a time.
Thanks,
JK