Determine month's of report cells to add to calculation 1

[rdjohnso]

I am trying to populate these four cells in my report..
from the monthly cells above... but based upon if it is the current year or the next year... Screenshot

The Monthly Hours and Cost are already calculated via a Function.. so I am unsure how I should do this....

I would typically do something like this....
=[MonthlyHours1]+[MonthlyHours2]+[MonthlyHours3]+ .....

But... I have to dynamicly determine if the current month and subsequent months fall within the current or future year...

Please advise...

Thanks

Ron

 

[Zion7]

If Year(txtDate) = Year(Date) Then

 

[rdjohnso]

Thanks Zion... so elementry.. it makes sense..!!