Date Change

J

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!
 
D

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.)
[email protected]
[email protected]
New Delhi, India
 
G

Glenn

Janie said:
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!
Click to expand...

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...
 
J

Janie

Glenn said:
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...
Click to expand...

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.
 
J

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
 
Top