Category - Date and Time

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.