Hi all experts, this is probably a very simple question but I am just stuck
here.

A1 is a Date, how can I read from A1 and write a column in another worksheet
of the date from first day to last day of the month and year of A1?

Many thanks in advance!