How to get first day of the month in Excel

To get the first day of the month for a given date, you can use two simple approaches: using EOMONTH function or using DAY function.
>