Thread: [Solved] Networkdays per fiscal year in a 6 year range
View Single Post
 
Old 10-15-2014, 11:50 AM
jabnm jabnm is offline Windows 7 64bit Office 2007
Novice
  
Join Date: Oct 2014
Posts: 2
jabnm is on a distinguished road
Default Networkdays per fiscal year in a 6 year range
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?
Last edited by jabnm; 10-15-2014 at 11:53 AM. Reason: lines ran together
Reply With Quote