As a user, I would like to be able to have an automation scheduled for the last day of the month (but not 28 day).

Maybe add a drop-down saying "Last day of the month". Or allow dates after 31, that in case month has less would use the last day.