What I need:
I need to automatically calculate hours for a particular work group if a
user answers a question "YES" in a cell on another sheet. Our fiscal
calendar is July thru June.
I have 5 cells, one for each of the next 5 fiscal years (or portion thereof
for the current year), for which I need to calculate these hours.
The calculation would be: Number months remaining in fiscal year x 4 hours
+12 hours for the first month in the first year only.

What I have:
CELL A1 - A user enters the starting month and year a project will
start(from a drop down list - format is Date Oct-06) .
CELL A2 - He/she then enters in the next cell the duration (format - whole
numeber) representing months that the project will run (projects can run from
1 month to 60 months).
CELL A3 - calculates the ending month/year using A1 & A2 (format is Date
Oct-06).