Hello,
I'm looking for help with a calendar based program. The issue goes like this:
I am trying to project out into the future when an activity will occur, it's just like a changing your AC filter. Evey three months i want to show this occurring.
The issue with this is that I can not figure out how to program this activity for several weeks or columns out in the future for each entry.
So in Column F it tells me how many columns or weeks I progress into the furture repeatedly from the Start Date. At each stop I need to enter in the number of hours like shown below.
Anyone able to direct me as to how to figure this out?
Column F Column G Column H Column I Column J Column K Column L Column M
Frequency Start Date Number of hours 1/2/2012 1/9/2012 1/16/2012 1/23/2012 1/30/2012
in weeks
2 1/9/12 2 2 2
1 1/2/12 6 6 6 6 6 6
3 1/2/12 3 3 3
If I did it right there should be an attachment that is a much better view.
Bookmarks