Need help with date ranges in Excel

Hi there! I need help trying to figure how to create a worksheet that will allow me to work with different sets of date ranges. For example, I have a date range with a number of hours between the two dates. I have to take those hours and divide them among a different set of date ranges. The date range with hours is very random and the dates I need to split this group among are always a set range of dates (i.e., fiscal years).

example: I have 3,567 hours between 3/31/15-6/17/17. My standard set of date ranges i need to split the hours to are: 9/30/14-9/29/15,9/30/15-9/29/16,9/30/16-9/29/17.

i know how to do this manually but it's taking far too long. Any ideas as to how I could use formulas and or macros to make a sheet that I can enter date ranges with its hours into, so it can split it out automatically? I'm fairly new at this so I'm still in the process of learning.

Thanks in advance!

Sorry for the confusion. Here is an example:

I have 3,567 hours to schedule between 3/31/15-6/17/17. I need to split the total hours into three seperate pieces in order to get them into three different date ranges. Manually, this comes out to the table below.

Out of 3567 hours, they would be broken out as follows:

9/30/2015-9/29/2015 802
9/30/2015-9/29/2016 1,618
9/30/2016-9/29/2017 1,146
Total 3567

Hopefully this makes sense. I'm trying to get a sheet setup that i can enter dates into and it'll automatically split everything out