Project days allocation
 

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 Jun
1/7-2/3 2/4-3/2 3/3-4/6
4/7-5/4 5/5-6/1 6/2-7/6
available days 20 20 25
20 20 25

--------------------------------------------------------------
proj start proj stop project duration

5/1/08 6/15/08 32 work days 0 0 2
20 12

Project days allocation
 

See the response(s) to 'Project days allocation (better mail format)'

On Mon, 5 May 2008 05:45:02 -0700, dumbaswood
wrote:

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 Jun
1/7-2/3 2/4-3/2 3/3-4/6
4/7-5/4 5/5-6/1 6/2-7/6
available days 20 20 25
20 20 25

--------------------------------------------------------------
proj start proj stop project duration

5/1/08 6/15/08 32 work days 0 0 2
20 12