=IF(MONTH($A$1)=MONTH(DATE(YEAR($A$1),
MONTH($A$1),ROW(A1))),DATE(YEAR($A$1),MONTH($A$1), ROW(A1)),"")

Copy down to 31 rows

--
Kind regards,

Niek Otten

"Toto Sanderson" <Toto wrote in message
...
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!