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
    https://brainmass.com/business/business-management/need-an-excel-date-solution-30941

    Attachments

    Solution Preview

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

    $2.19

    ADVERTISEMENT