MONTH_START

First date of the month for a date value.

Examples

• MONTH_START(‘4/15/25’) - Returns 04/01/2025.
• MONTH_START(D5) - Returns the first date of the month for the date in cell D5.
• MONTH_START(date{!1}) - Returns the first date of the month for the first date in the date field.