Formula to translate from year to eomonth

[Keibri]

Hi guys,

I was wondering whether someone can help me with the below.

I have a worksheet and in cell A1 the user is going to be inserting the year in question e.g. 2019, or 2020 etc

In cell A3 up untill A14 I need to insert the end of month for that year. Is there a way to do it automatically through a formula?

For ease of reference I have attached an example

Appreciate a lot your kind help

Regards

Keibri