Date Change

[Janie]

I would like to print 30 pages of a sheet (appointment sheet) I created but I
would like the date to change on each page printed. Is this possible? The
date needs to start in NOvember 2009. Help!

 

[DILipandey]

Hi Janie,

You can use insert date at the Header of each page. Go to print preview and
then go to Setup -> Header / Footer and click on Custom Header. Here you
will find the options to set the current date at the top of each sheet.

Thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India

 

[Glenn]

I would like to print 30 pages of a sheet (appointment sheet) I created but I
would like the date to change on each page printed. Is this possible? The
date needs to start in NOvember 2009. Help!

Where is the date on your worksheet? In a cell? In the footer?

Does the date need to start on a specific date in November 2009? By how much do
you want the date to change on each page? One day, one week, one month,
something else...

 

[Janie]

Where is the date on your worksheet? In a cell? In the footer?

Does the date need to start on a specific date in November 2009? By how much do
you want the date to change on each page? One day, one week, one month,
something else...

I'll put the date anywhere, as long as it makes formatting a formula easy.
I would like it to change daily starting with November 12, 2009.

 

[Janie]

I don't think it will automatically add a day to the date. I probably did
not explain myself very well.

Thank you though