Try this
Formula: copy to clipboard
=DAY(EOMONTH((1&A1),0))

v A B
1 April 30