EWOMONTH()

Returns the date of the last weekday (Monday through Friday) of the month specified by the Date or DateTime value.

Sample usage

EWOMONTH("3/15/2020", 3) returns 6/30/2020

EWOMONTH("2/1/2020", 0) returns 2/28/2020

EWOMONTH(TODAY(), 0) or EWOMONTH(NOW(), 0) returns the date of the last weekday of the current month. See also: NOW(), TODAY().

EWOMONTH(TODAY(), 1) returns the last weekday of next month.

EWOMONTH(TODAY(), -1) returns the last weekday of last month.

Syntax

EWOMONTH(when, offset-months)

• when - A Date or DateTime value.
• offset-months (Number): A number of months to add to or subtract from when before computing the last day of the month. For instance, 0 would find the end of the month specified by when; 1 would find it for the month after when; and -1 would find it for the month prior to when.

See also

EOMONTH()

EOWEEK()

WORKDAY()