# Monthly split from date range

#### jaydj1

##### New Member
Hi, I'm trying to find the best formula for my spreadsheet that shows me the number of months within a fiscal year, with a start and end date range . Could someone help?

### Excel Facts

VLOOKUP to Left?
Use =VLOOKUP(A2,CHOOSE({1,2},\$Z\$1:\$Z\$99,\$Y\$1:\$Y\$99),2,False) to lookup Y values to left of Z values.

#### jaydj1

##### New Member
01/10/200901/10/201001/10/201101/10/201201/10/201301/10/201401/10/201501/10/201601/10/201701/10/201801/10/201901/10/202001/10/2021
StartEndPriorFY 10FY 11FY 12FY 13FY 14FY 15FY 16FY 17FY 18FY 19FY 20FY 21FY 22
01/01/201931/12/202000000000093
01/11/201830/04/201900000000060
 01/10/2009 01/10/2010 01/10/2011 01/10/2012 01/10/2013 01/10/2014 01/10/2015 01/10/2016 01/10/2017 01/10/2018 01/10/2019 01/10/2020 01/10/2021 Start End Prior FY 10 FY 11 FY 12 FY 13 FY 14 FY 15 FY 16 FY 17 FY 18 FY 19 FY 20 FY 21 FY 22 01/01/2019 31/12/2020 0 0 0 0 0 0 0 0 0 9 3 01/11/2018 30/04/2019 0 0 0 0 0 0 0 0 0 6 0

<colgroup><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>

<colgroup><col span="12"><col><col span="3"></colgroup><tbody>
</tbody>

Replies
16
Views
284
Replies
0
Views
85
Replies
1
Views
204
Replies
0
Views
34
Replies
2
Views
415

1,127,031
Messages
5,622,308
Members
415,891
Latest member
Oksana88

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back