Date in Footer

[Karen]

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