| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date Change
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! |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Change
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.) New Delhi, India "Janie" wrote: 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! |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Change
Janie wrote:
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... |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Change
"Glenn" wrote: Janie wrote: 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... 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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Date Change
I don't think it will automatically add a day to the date. I probably did
not explain myself very well. Thank you though "DILipandey" wrote: 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.) New Delhi, India "Janie" wrote: 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! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change satellite julian date format YYYYDDDHHMMSS to excel date ti | Excel Discussion (Misc queries) | |||
| Use date modified to change format & create filter to track change | Excel Worksheet Functions | |||
| change background row color with change of date in a cell | Excel Discussion (Misc queries) | |||
| I want any date 90 days or older from current date change color | Excel Worksheet Functions | |||
| Make date change in excel to current date when opening daily? | Excel Discussion (Misc queries) | |||
Linear Mode
