Formula to calculate how many days in a month have Daylight Savings

Originally Posted by Bo_Ry

Please try

=WORKDAY.INTL(--("oct"&LEFT(O2,4))-1,1,"1111110")

or

=--("oct"&LEFT(O2,4))-WEEKDAY(("oct"&LEFT(O2,4)),11)+7

That works.

However still when 2017/18 is the year the End date should be 1/4/2018 not 8/4/2018.