Date formula?

[Becca]

I have who wants to create a formula in Excel that prints
the date on the top of each page, and increments on the
top of every next page. They want the date to be increased
by one day on every new page.
Is this even possible?

 

[Frank Kabel]

Hi
do your sheet names have a kind of logic. E.g. are named like
day_1
day_2
day_3
etc.

If yes please provide your naming convention and this can be done using
INDIRECT and CELL function calls

 

[Gord Dibben]

Becca

First, let us establish what you mean by "page" and "print".

A workbook contains one or more worksheets. Some people call these "pages".

A worksheet or workbook can contain one or more printed pages when doing a
hard-copy print-out.

When you use the term "page" and "print", what are you referring to?

How we answer will depend upon your reference.

Gord Dibben Excel MVP