Skip to content

[Excel] Days in Month

=DAY(DATE(YEAR(A1);MONTH(A1)+1;1)-1)

, where A1 contains a valid date.