Hi

The formula
=A1+B1*14 gives your start date
=A1+B1*14+14 gives your end date
dependent upon where you are storing your Payroll year Start date and where
you are entering your Period number.

Just insert these formulae into the cells you originally had dates in.

Regards

Roger Govier


bdehning wrote:
Ok I got what your say now as I can have all that Text come from one field
across the spreadsheet and can insert spaces to move it as I need to fill in
the areas.

Now the issue I have is that I lost the ability to show every day of the
week with the date as I used to key off the the Through Date Field by cell
number. Unfortunately now with the heading field I lost that field to key
on.

What can I use now to have the 14 days of the week show the correct date in
a field next to the Day of the week whenever the Pay Period is changed and
not lose the formula you supplied that does work?