MonthStart(date)

Category: Date and Time function

Description

This function returns the date serial number of the first day of the month date falls in.

Argument	Type	Description
date	Date or Number (date serial)	An expression representing a date to derive the month's first day date value from.

Return value type: Date serial number

The date argument can take any value or expression that evaluates to a date serial value. Examples include:

A date string: #2019-12-12
A date serial value: 43811 (the date serial for "2019-12-12")
A date value created using any of the Date/Time functions that returns a date serial value.

monthstart(#2018-06-06)  //Returns 43252 (Equivalent to June 1st, 2018.)

monthstart(#2020-01-28)  //Returns 43831 (Equivalent to January 1st, 2020.)