I am working on revamping an old timesheet, which currently has the
entire year on one sheet. Typically, we have to re-enter the dates for
each new year, which can be a very messy proposition, especially if the
time coordinator rearranges the size of the sheet.
We are considering moving to separate sheets for each pay period and
the utilizing some sort of auto-populate for the new year's dates, on
each sheet. Is there such a way to quickly populate cells in Excel?

Thanks
Louis

use a single cell as a base date. Then all other cells would use a formula
like

(Assume A1 holds the base date).
A2: =A1+1
A3: =A2+1

with the cells formatted as dates.

Obviously you can get more sophisticated with the formulas if necessary.

--
Regards,
Tom Ogilvy


"ll" wrote:

I am working on revamping an old timesheet, which currently has the
entire year on one sheet. Typically, we have to re-enter the dates for
each new year, which can be a very messy proposition, especially if the
time coordinator rearranges the size of the sheet.
We are considering moving to separate sheets for each pay period and
the utilizing some sort of auto-populate for the new year's dates, on
each sheet. Is there such a way to quickly populate cells in Excel?

Thanks
Louis