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!