D
Dian Volschenk
Good morning all.
I am hoping some one migh have a solution for me. I have a complex
sheet that takes an x amount of man hours and distributes it among an
x number of months based on a start and a finish date.
Now my formula distiputes the hours evenly among the months based on
the days in the month and also refrences a secondary sheet with
industry standers for a percentage of work that should be done that
month.
Now my problem is say I have a late start at the 15th of the month, I
can only work a cetrain amount of hours witch is ok, but I want to add
the remaining hours to my very last month. Is there an condition that
I can write to refreence my end date and implement a sum function
then.
Basically say my end date is Dec 2012- when my time line reaches
Dec-2012 can it activate my sum as to add the missing value from the
missed hours at the start of the month.
I am hoping some one migh have a solution for me. I have a complex
sheet that takes an x amount of man hours and distributes it among an
x number of months based on a start and a finish date.
Now my formula distiputes the hours evenly among the months based on
the days in the month and also refrences a secondary sheet with
industry standers for a percentage of work that should be done that
month.
Now my problem is say I have a late start at the 15th of the month, I
can only work a cetrain amount of hours witch is ok, but I want to add
the remaining hours to my very last month. Is there an condition that
I can write to refreence my end date and implement a sum function
then.
Basically say my end date is Dec 2012- when my time line reaches
Dec-2012 can it activate my sum as to add the missing value from the
missed hours at the start of the month.