Examples

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

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

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

EWOMONTH(TODAY(), 1) : Last weekday of next month.

EWOMONTH(TODAY(), -1) : Last weekday of last month.

EWOMONTH(TODAY(), 0) + 3 : First weekday of next month.

EWOMONTH(TODAY(), -1) + 3 : First weekday of this month.

EWOMONTH(TODAY(), -2) + 3 : First weekday of last month.

Syntax

EWOMONTH( when , offset-months )

Arguments

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

Return Value

Date: The date of the last weekday--Monday through Friday--of the month specified by when if when is recognized as a Date or DateTime value.

See Also

EOMONTH(), EOWEEK(), WORKDAY()

Did this answer your question?