Auto Fill Pay Periods
There must be a post already with answers but I can't seem to locate it so I
need some help.
I have an Excel Spreadsheet where I have field called Pay Period and would
be 1-26 for the year.
How do I set up the sheet so that when I enter a specific Pay Period, fields
for Report Dates_________ through ______________ are filled with the
correct 14 day period for that Pay Period entered?
For example if Pay Period 25 the fields would be 11/27/05 and 12/10/05.
--
Brian
|