C29:I29 is seven days, not Monday to Friday

Same for K29:Q29

Maybe try this and see if it is close.

In C29 enter =$F$25+COLUMN()-3

Copy that across to I29

In K29 enter =$F$25+COLUMN()-4

Copy across to Q29

Pick a start date from F25

BTW..........in Excel we call them "cells" not "boxes"


Gord Dibben MS Excel MVP


On Thu, 28 Jan 2010 14:39:01 -0800, SethT
wrote:

I need to set up dates to automatically populate from a data validation drop
down box for a time sheet that I am making for work.

The data validation box is F25 and the boxes that I need to auto populate
when each one is selected for the pay periods are boxes C29-I29 and K29-Q29,
which is monday through friday for each pay period over 2 7 day weeks.

Does anyone know how I can do this relatively easily?