STARTOFMONTH function

  • 2 February 2022
  • 0 replies
  • 94 views

Userlevel 3
Badge +2
  • 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 alsoEDATEMONTH EOMONTH


0 replies

Be the first to reply!

Reply