View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bdehning
 
Posts: n/a
Default 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