Explore BrainMass

Explore BrainMass

    Need an Excel Date Solution

    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.

    © BrainMass Inc. brainmass.com June 3, 2020, 5:34 pm ad1c9bdddf


    Solution Preview

    Please refer to attachment.
    Note: we divide each contract into every fiscal year based ...