Hello everyone,

Please consider the following scenario: I have a set of resource for which
the total resource hours remaining (A1) for a year (Jan to Dec) has been
calculated by subtracting the scheduled hrs. from the total hrs. Lets say I
have project start date as "May 1, 2005' and end date 'April 30, 2006' and
from this I can find the time in hrs between these two dates. Now I have to
find the resource availability for this period. I know the resource
availability for the present year (A1) (that is from May 1 to Dec 31). But I
need to know the resource availability till April 30, 2006. I understand that
I should add the resource availability for this year and resource hrs for the
period Jan to April of 2006. I was wondering whether I can get a formula to
automate it since I will be dealing with many projects which may begin and
end at any date of the year. Please help me out. Thanks for your suggestion
in advance.

KT