Calculate date to required end of month

Hi all.

Using DateAdd("m", 3, Date), I can return a date exactly 3 months from the current date. No difficulty there, elegant and simple to expand on.

I have a requirement, however, to return a specific date within a frame. e.g

If the date falls between 1/1/16 and 31/03/2016, then the returned date must be 31/03/2016.
If the date falls between 1/4/16 and 30/06/2016, then the returned date must be 30/06/2016.

I am looking for a relatively elegant solution to this question. But it must be able to handle future years also. (e.g. 2016, 2017...2020, etc)

Can anybody show me a way to do this.

Cheers

Oh c'mon!!

If you had to ask for a workbook then you didn't read the question. I also note that this is a generic response that you almost always copy/paste in your answers.

The question is clearly presented and asked. It wastes my time and yours, and leads other to believe that somebody is helping with the issue, when they are in fact not.

Please don't respond if you didn't read or understand this very clearly defined question.

Alan, I apologise if my tone seemed a bit harsh, however, I had carefully considered the question when writing it, and since my question was specifically VBA related, did not at all believe that posting a book was relevant, or the request for one helpful.

Thank you Bulinak. I appreciate the effort to understand the problem, and provide an example. I followed your example and used a select case instead of If then (mostly because I had more than two conditions)

Please Login or Register  to view this content.

This was the shortest way I could think to do this, and still uses Dateadd

Cheers and take a rep for your response!