| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Date in Footer
Is there a way of putting a formula into a footer?
For example: In Sheet 1 (footer) I have a date (12/1/04) In sheet 2 (footer), I want the date to advance one day (12/2/04) and then in sheet 3 (footer), I want the date to advance one day (12/3/04) etc. Is there a way of doing this? If not, I guess I'll have to put the date in a cell Thank you, Karen |
|
#2
|
|||
|
|||
|
Hi
only possible using VBA -- Regards Frank Kabel Frankfurt, Germany "Karen" schrieb im Newsbeitrag ... Is there a way of putting a formula into a footer? For example: In Sheet 1 (footer) I have a date (12/1/04) In sheet 2 (footer), I want the date to advance one day (12/2/04) and then in sheet 3 (footer), I want the date to advance one day (12/3/04) etc. Is there a way of doing this? If not, I guess I'll have to put the date in a cell Thank you, Karen |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Date updates from worksheet to chart & changes date to a date series! Help!! | Charts and Charting in Excel | |||
| Date issue between Windows and Macintosh version | Excel Discussion (Misc queries) | |||
| Print Footer with Last Print Date field name | Excel Discussion (Misc queries) | |||
| Addition to Turn cell red if today is greater or equal to date in cell | New Users to Excel | |||
| Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions | |||
Linear Mode
