Skip to main content
Documentation
Documentation
Workday User Guide
Last Updated: 2023-06-23
EOMONTH

EOMONTH

Description

Returns the date of the last day of the month (ending in the evening at 11:59:59.999 PM or 23:59:59.999) using the specified start_date and number of months to add or subtract.

Syntax

EOMONTH(
start_date
,
months
)
  • start_date
    : The date to determine the last day of the month for. Workday recommends using a cell reference to specify the date instead of entering the date as text, to ensure reliable results.
  • months
    : The number of months to add or subtract from the
    start_date
     before determining the last day of the month.

Example

Formula
Result
=EOMONTH("15-Dec-2016",5)
5/31/2017
=EOMONTH("15-Dec-2016",-5)
7/31/2016

This content is not part of the Workday Administrator Guide.