How to get the beginning and end of the month?

Question

Visual Basic

Good afternoon, in Excel there is a column (let it be column A) with dates and another column (column B) with hyperlinks to documents. Column A puts the date when the document arrived at the department, for example, in the current month the documents were on the 3rd, 6th and 25th, therefore the table will look like this It is

not necessary that there will be exactly 3 documents in the month, maybe be more, maybe less, how to get the beginning and end of the month using VBA or formulas? For example 3rd and 25th number?

Answer 1

and ends on the 25th

How is the end of the month determined? How to understand that the month ends on the 25th, and not on the 26th or 30th?