Need an Excel Date Solution
Not what you're looking for? Search our solutions OR ask your own 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.
© BrainMass Inc. brainmass.com December 24, 2021, 5:08 pm ad1c9bdddfhttps://brainmass.com/business/business-management/need-an-excel-date-solution-30941
Solution Preview
Please refer to attachment.
Note: we divide each contract into every fiscal year based ...
$2.49