need formula to create calendar

  • Thread starter Thread starter Mark W.
  • Start date Start date
M

Mark W.

I need some help with this:
I created a calendar where in A1 I have this formula:
="Calendar" &YEAR(NOW())
It's a header that supposed to automatically display correct
year on Jan 1 of every year (at least I hope it will)
The only thing is that I can't separate Calendar from Year,
it comes like this: Calendar2004.
This is the first problem, second:
In B3 I entered date (in this case 1/1/04) but it displays only the
number of a day (01), B2 reads B3 but displays first three letters
of the day (Mon, Tue. etc.)
How can I set up cell B3 and following cells (C3, D3, E3. etc.) so
they automatically change every year on Jan 1 I mean B3 will
automatically read 1/1/05, C3 1/2/05 etc. this way I would not
have to set it up every year.
Appreciate your help

Mark
 
Mark,

As far as the spacing, simply add a space to your string:
="Calendar " &YEAR(NOW())

As for the rest, I have a neat little calendar spreadsheet that would
be easier to mail to you than to explain. Contact me privately and I
will send it to you.

HTH,
Bernie
MS Excel MVP
 
Hi Mark!

="Calendar "&YEAR(NOW())

Set B3 C3 etc. format at m/d/yy

Formula for B3:
=DATE(YEAR(NOW()),1,1)
Formula for C3
=B3+1

I've got a calendar file I'll send to you if you email me.

Also there's one downloadable from:

Chip Pearson:
http://www.cpearson.com/excel/download.htm

Both should give you lots of ideas
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
Hi Mark!

="Calendar "&YEAR(NOW())

Set B3 C3 etc. format at m/d/yy

Formula for B3:
=DATE(YEAR(NOW()),1,1)
Formula for C3
=B3+1

I've got a calendar file I'll send to you if you email me.

Also there's one downloadable from:

Chip Pearson:
http://www.cpearson.com/excel/download.htm

Both should give you lots of ideas
Click to expand...

Thanks,
I got it the way I want it now
appreciate
Mark
 
Back
Top