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.© BrainMass Inc. brainmass.com March 4, 2021, 6:08 pm ad1c9bdddf
Please refer to attachment.
Note: we divide each contract into every fiscal year based ...