Project days allocation

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 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
 
T

Tushar Mehta (Microsoft MVP Excel 2000-2008)

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top