I need a formula to calculate the networkdays by fiscal year for a list of tasks based on their start and end dates. The start and end dates can occur anytime over a range of 6 years. It will calculate the number of networkdays which fall within each fiscal year. The fiscal year is October 1 through September 30.

Fiscal years: 2015, 2016, 2017, 2018, 2019, 2020

Sample start and end dates:
10/15/2014 to 0/15/2016
12/18/2014 to 1/7/2015
10/6/2014 to 7/9/2018
5/12/2016 to 11/9/2016
11/15/2016 to 5/15/2017
3/31/2016 to 5/17/2018


3/31/2016 to 5/15/2017
7/27/2018 to 9/26/2019
8/30/2019 to 10/10/2019

Is there a way to do this in Excel?

Cross post http://software.techassistbox.com/ne..._10483031.html
http://help.howproblemsolution.com/9...a-6-year-range

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post