=A1+7

Does that work for you?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

<Jim Hammerel wrote in message ...
| I'd like to create a timecard-style spreadsheet where I can enter the date of the start of the pay period (in 6/15/2008 format)
and have that auto populate the following dates on a 7-day/week calendar on the corresponding days of the week.