Really stuck on this one. I have projects that are running between 2 dates (Project Approval Date and the Estimated Completion date). I need to summarize the monthly project management fee (column G) by Fiscal Year.
Overall, I am trying to create a formula to calculate the amounts in column L through to Q, to summarize the monthly journal amounts by fiscal year.
I am really stuck on this one and I am hoping that someone out there can assist.
Sincere thanks in advance,
A