BOMONTH
Returns the first day of the month for a given date (Beginning Of MONTH)
Usage
BOMONTH(date)
Parameters
date |
(Required) The date from which to determine the beginning of the month |
Examples
More information
The function returns the first day of the month for the given end_date.
The name comes from “Beginning Of MONTH”.
Reminders
A text containing a date is not handled as a date. To have an actual date:
- use the
@DATE_QUESTION
to set the variable - use a function that converts to a date:
DATEVALUE(text_date)
- use a function that returns a date:
TODAY()
orDATE(year, month, day)