Hi Duke,
I guess I do not have the toolpak because this did not work. Thanks,
JK
"Duke Carey" wrote in message
...
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
|