Payroll spreadsheet help

[benze0107]

I am attempting to create a payroll spreadsheet for use at my office. We're currently using a Word document and everything requires manual input.

The spreadsheet I have in mind will allow the employee to input the pay period start date and end date and the dates will auto generate (currently each day in the pay period has to be changed each time you fill it out). This didn't pose a problem at first, but I'm at a loss now.

Basically, I want it to stay generally the same:

http://img409.imageshack.us/img409/381/doc000bh3.jpg

I'm just not sure how to make Excel know where to put the days and still keep the correct format. If it weren't for the fact that our pay periods begin on a different day each period (as in, it might start on Wednesday for one period, but on Monday for the next) and they don't have the same number of days (it is always anywhere from 10 days to 12 days) this wouldn't be as hard, but right now, I'm at a loss.

Thanks so much!

[BigBas]

Set up a formula of sorts to populate the dates.

For example, if your date is in A1, containing the Payroll Period ending, set the days to subtract from that.

If your pay period ends on a Saturday, Friday can be: =A1-1

Play around with that idea.

[benze0107]

I had thought about doing that, it's just that we have no set pay period end date (as in, the last day is on Friday each time...sometimes it ends on a Friday, sometimes a Tuesday, etc) and the number of days in our pay period changes from period to period.

If it were just a flat two weeks, it would be easy peasy. :/