rutgermons
asked on
excel vb macro, forecasting based on date per project
Folks
I want to display projects in a sheet that happen on regular intervals over a calendar per work
i.e.
PROJECT FREQUENCY INTERVAL START DATE WEEK1 WEEK2 WEEK3
SERVICE CAR 14 DAYS 01/01/2014 X X
CHECK OIL 7 DAYS 08/01/2014 X X
how can we do this in excel?
PM-FORECASTER.xlsx
I want to display projects in a sheet that happen on regular intervals over a calendar per work
i.e.
PROJECT FREQUENCY INTERVAL START DATE WEEK1 WEEK2 WEEK3
SERVICE CAR 14 DAYS 01/01/2014 X X
CHECK OIL 7 DAYS 08/01/2014 X X
how can we do this in excel?
PM-FORECASTER.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I should have noted that I changed Week1, Week2, Week3... to the dates that each week begins on.
Thomas