In A1 enter Pay Period

In A2 enter the start date of 12/22/2008

In A3 enter =A2 + 14 drag/copy down as far as you wish to cover 2009

In B1 enter Paycheque Date

In B3 enter =A3 + 4 copy down.


Gord Dibben MS Excel MVP

On Mon, 8 Dec 2008 10:29:02 -0800, rsantoyo
wrote:

List of biweekly payperiods that start on Monday 12/22/08, Pay Period ends
Sunday 1/4/09 and paycheck date is Thursday 1/8/09. For formula in excel to
do this automatically for 2009 and I won't have to do it manually.