Forum Discussion
Counting the number of each month between two dates?
Howdy, I am attempting to build a calculator that quantifies weather days in a time period by first quantifying the number of each month (EX: January: 3, Feburary: 3, March: 2, etc...) between tw...
As variant
=YEAR($I$16) - YEAR($G$14) +
( (YEAR($G$14)*100 + MONTH(1&F18) ) >= (YEAR($G$14)*100+MONTH($G$14) )) *
( (YEAR($I$16)*100 + MONTH(1&F18) ) <= (YEAR($I$16)*100+MONTH($I$16) ))here
and copy/paste to other cells.