Excel MAGIC TRICK - How to display the FIRST and LAST DAY OF THE MONTH, along WITH ANY TEXT?
In this Microsoft Excel tutorial you will learn "How to automatically display the first and last day of the month, along with any text?". And you only need ONE FORMULA to get this done.
With these instructions and the MS Excel formula, you will be able to enter any date in your company invoices or other documents, and excel will automatically show you the first and last day of this month and add text next to it, e.g. "from day XXX to day XXX" in the month in which the entered date is located. With this formula, you will save a lot of time, because Excel will automatically enter the data for you.
You can also use this MS Excel formula in your dashboards. It's interactive and you can combine it with data entry for the year.
The formula I used:
="from &" "&TEXT((DATE(2022; MONTH(D6); 1));"d. m. yyyy")&" to "&TEXT((EOMONTH(D6; 0));"d. m. yyyy")