Explore BrainMass

Explore BrainMass

    Need an Excel Date Solution

    Not what you're looking for? Search our solutions OR ask your own Custom question.

    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 December 24, 2021, 5:08 pm ad1c9bdddf


    Solution Preview

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