Monthly split from date range

jaydj1

New Member
Joined
Feb 11, 2019
Messages
2
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?

 

jaydj1

New Member
Joined
Feb 11, 2019
Messages
2
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/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

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

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

Forum statistics

Threads
1,084,993
Messages
5,381,066
Members
401,713
Latest member
BraydenMSB

Some videos you may like

This Week's Hot Topics

Top