ExcelBanter - Date in Footer

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Date in Footer (https://www.excelbanter.com/excel-worksheet-functions/6899-date-footer.html)

Karen

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

Frank Kabel

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

All times are GMT +1. The time now is 04:20 PM.