Thread: dates formula
View Single Post
  #3   Report Post  
Leo Heuser
 
Posts: n/a
Default

Jerry

One way:

In A2 (formula on one line)

=IF(ROW()-ROW(A$2)+1DAY(DATE(2005,COLUMN()-
COLUMN($A2)+2,0)),"",ROW()-ROW(A$2)+1&" "&A$1)

Copy A2 to B2:L2 with the fill handle (the little square in the lower right
corner of the cell)
Copy A2:L2 to A32:L32 with the fill handle.

If you want to get rid of the formulae, then, while A2:L32 is
selected, do a Copy (<Ctrlc), select Edit Paste special
and choose "Values", OK.
Finish with <Esc and clicking a cell.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

"Jerry Kinder" skrev i en meddelelse
m...
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