Forum Discussion
Need a formula for months of a year from a given date range
I have the following in my spreadsheet: Hours/Month(a) Start Date(b) End Date(c) 2020 2019 2018 2017 2016 40 9/1/2017 ...
In D2:
=$A2*IFERROR(DATEDIF(MAX(DATE(D$1,1,1),$B2),MIN(DATE(D$1+1,1,1),$C2),"m"),0)
Fill to the right (and if applicable, down)