With Excel, you can build your dynamic date very easily. Discover how to build a dynamic date in this article.
This article is a glossary of all the Excel functions to return the first day or the last day of the Month, the Quarter or the Year
The function DATE is very useful to create your custom dates. This article will explain you how the function works