LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Macro for Auto Fill carolini Excel Discussion (Misc queries) 2 December 6th 05 09:11 PM
stop auto fill from thinking for itself!!!!!!! 1vagrowr New Users to Excel 3 November 5th 05 03:27 PM
Auto Fill Options adarling Excel Discussion (Misc queries) 1 April 8th 05 03:09 AM
Auto fill option box disappeared sbrimley Excel Worksheet Functions 5 February 4th 05 03:21 AM
Auto Fill Options Patti B Excel Discussion (Misc queries) 3 December 9th 04 12:49 AM


All times are GMT +1. The time now is 07:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"