1. Business
2. Business Management
3. 30941

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Attached is an Excel spreadsheet with contract dates and data. Contracts may cover all or part of a fiscal year or multiple fiscal years. I need an algorithm to allocate each contract total dollars to each fiscal year the contract covers based on the number of days in each fiscal year. The fiscal years commence 1 October and end 30 September.