Returns the last day of the month for a given date.

Usage

EndOfMonth(date)

date (required) The date from which the month is to be computed.

Example

Extract the last day of the month from the [Invoice Date] column:

EndOfMonth([Invoice Date])

Screen_Shot_2020-07-30_at_12.29.26_PM.png

Related Documentation

LastDay