D
dumbaswood
i have a project that is 32 workdays and i want to spread the 32 work days by
month until the 32 days are used up. my project starts on random dates and
end on random deate and can cross multiple months. my fiscal months are not
calendar months. i have calculated how many work days there are in my fiscal
months so i want a formula that will "bounce" against the available days i
have to allocate. So, below i am looking for a formula that will calculate 2,
20 and 12 = 32
Jan Feb Mar Apr May June
1/7-2/3 2/4-3/2 3/3-4/6 4/7-5/4 5/5-6/1 6/2-7/6 fiscal
20 20 25 20 20 25 workdays
--------------------------------------------------------------
proj start proj stop project duration
5/1/08 6/15/08 32 work days
Needed answer to be:
0 0 0 2 20 12 0
month until the 32 days are used up. my project starts on random dates and
end on random deate and can cross multiple months. my fiscal months are not
calendar months. i have calculated how many work days there are in my fiscal
months so i want a formula that will "bounce" against the available days i
have to allocate. So, below i am looking for a formula that will calculate 2,
20 and 12 = 32
Jan Feb Mar Apr May June
1/7-2/3 2/4-3/2 3/3-4/6 4/7-5/4 5/5-6/1 6/2-7/6 fiscal
20 20 25 20 20 25 workdays
--------------------------------------------------------------
proj start proj stop project duration
5/1/08 6/15/08 32 work days
Needed answer to be:
0 0 0 2 20 12 0