Purchase Solution

Need an Excel Date Solution

Not what you're looking for?

Ask Custom Question

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.

Purchase this Solution

Solution Preview

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

Purchase this Solution


Free BrainMass Quizzes
Organizational Leadership Quiz

This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.

Team Development Strategies

This quiz will assess your knowledge of team-building processes, learning styles, and leadership methods. Team development is essential to creating and maintaining high performing teams.

Accounting: Statement of Cash flows

This quiz tests your knowledge of the components of the statements of cash flows and the methods used to determine cash flows.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.