Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 13
Default Calculations using dates -- HELP!

I'm wanting to create a spreadsheet based on hours available and copy to the
start and end dates on a 4-month calendar by week. Can this be done, and if
so, which function do I use?

My Example by Week: Available/ Available
Name: Start Date: End Date: Overbooked: Hours:
Lisa D. 2-Oct 13-Nov 1/4 .25

Within the same spreadsheet I'd like to spread the .25 hours automatically
without copying and pasting over a 4-month calendar by week:
4 month calendar by week:

2-Oct 9-Oct 16-Oct 23-Oct 30-Oct 6-Nov 13-Nov and so on...
..25 .25 .25 .25 .25 .25 .25

Here is my column layout:
C-A: Name
C-B: State Date
C-C: End Date
C-D: Available Staff (.25/.33/.50/.75/1.00)
C-E: Available Hours (Staff x 40)
C-F thru C-W: Hours Available/Overbooked Per Week

Thank you in advance for your help!!
LisaD.

Reply
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
working out quarters (three-month periods) between two dates [email protected] Excel Worksheet Functions 1 May 17th 06 10:27 AM
formula to add dates. S S Excel Worksheet Functions 8 April 5th 06 07:53 PM
Pre-1900 dates Richard Gadsden Excel Discussion (Misc queries) 1 March 26th 06 12:46 AM
2 digit year in dates return 19xx not 20xx moranbo Excel Discussion (Misc queries) 1 September 7th 05 01:44 AM
Formating Dates for production schedule dpl7579 Excel Discussion (Misc queries) 1 January 11th 05 08:43 PM


All times are GMT +1. The time now is 02:39 AM.

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

About Us

"It's about Microsoft Excel"