ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Calculations using dates -- HELP! (https://www.excelbanter.com/excel-discussion-misc-queries/110358-calculations-using-dates-help.html)

LisaD

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.



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

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com