N
N
Nikita072019-08-15 11:43:29
Visual Basic
Nikita07, 2019-08-15 11:43:29

How to get the beginning and end of the month?

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
5d68e46910c3b416166231.png
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 the question

In order to leave comments, you need to log in

1 answer(s)
R
Roman, 2019-08-15
@JohnnyBravo7

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?

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question