Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
find the beginning and end days of a project | New Users to Excel | |||
Calculate number days + hours to complete a project | Excel Worksheet Functions | |||
Excell error "Can't find Project or Library" Project VBAProject | Excel Worksheet Functions | |||
How to convert MS Project to MS Excel. I don't have MS Project. | Excel Discussion (Misc queries) | |||
F-key allocation | Excel Discussion (Misc queries) |