=day(date(year(a1),month(a1)+1,1)-1)

=networkdays(a1-day(a1)+1,date(year(a1),month(a1)+1,0))