STARTOFMONTH function

5 months ago
2 February 2022
0 replies
94 views

Userlevel 3

+2

Ben
Community Manager
8 replies

Description

Returns the first day of a month after or before a given date.

Syntax

STARTOFMONTH(start_date [, months_offset])

start_date (date) : corresponds to the date you want to start from.
month_offset (integer) , optional, 0 by default: corresponds to the number of months you want to offset.

Return type

date

Examples

Case	Results	Return Type
`STARTOFMONTH(28/11/2021)`	`01/11/2021`	`date`
`STARTOFMONTH(18/01/2021, 0)`	`01/01/2021`	`date`
`STARTOFMONTH(15/01/2021, 1)`	`01/02/2021`	`date`
`STARTOFMONTH(15/01/2021, -10)`	`01/03/2020`	`date`

Excel equivalent: none

See also: EDATE, MONTH , EOMONTH

0 replies

Be the first to reply!

Reply