Dating every third column?

[Bonita Kale]

I'm not a regular poster here, so if I'm asking a question that's very
common, please forgive me.

I did do a google groups search and found out that what I would like
to do--label multiple columns with one label--isn't possible in Excel
97.

But can I date every -third- column without doing it manually?

What I have is a sheet with a column labeled, say, "01/02/04", and
then two unlabeled columns (one applies to that date; the other is a
spacer) and then a column labeled "01/03/04", then two blanks, etc.

What I've been doing is revamping an old workbook--okay, I saved it as
a template, but it's just an old workbook--each time (I do a new one
every two months). I have to do searches and replaces for the dates,
and then patch them up individually as well. Is there an easier way?

(If it makes any difference, the dated column shows what foods; the
column next to it shows calories.)

Bonita

 

[Bob Phillips]

Bonita,

Try putting this formula in all relevant cells in your header row

=IF(MOD(COLUMN(),3)=1,DATE(2004,INT(COLUMN()/3)+1,1),"")

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Max]

It's quite straightforward to manually label the columns
in the manner you want, viz.:

1st month's label-blank-blank-2nd month's label-blank-blank ....

(i.e. to skip 2 blank cols in-between labels
& increment the month label)

Give this a try:

Put in A1: 01-Feb-04
Put in D1: 01-Mar-04

Select A1:F1 (<< note the range selected)

Drag and copy across to say, AH1
(to give a 12 months spread, Feb-04 to Jan-05)

The resulting labels should appear in the manner desired

 

[Peo Sjoblom]

Assume they start in A1, put 01/02/04 in A1, select A1:C1
move the cursor to the lower right corner of C1,
when it changes from a fat cross to a thin cross left click and hold
while copying across, that will return

Date Blank Blank Date+1 Blank Blank Date+2 Blank Blank and so on

 

[Bonita Kale]

Wow! Thanks to all of you--I'm going to try each method.

Bonita

 

[Max]

you're welcome, Bonita!
Thanks for feedback.
(from all of us <g>)

Rgds
Max