User Manual

10.03.2024

MANUAL

Formula (Extended): $EOMONTH Function

Overview

Calculate the last day of the month before or after the specified number of months from the start date.

Syntax

$EOMONTH(Start Date, Month)

Parameters

Parameter Type Required Description
Start Date Date or date string in yyyy/mm/d format Required
Month Half-width numerical value Required If a positive number is specified, a date after the start date is returned, and if a negative number is specified, a date before the start date is returned

Column Usable as Parameters

Parameter Classification Numerical Value Date Description Check
Start date Yes No Yes Yes No
Month Yes Yes No Yes No

Return Value

Date in yyyy/mm/dd format.

Return Value Display Content

Target Display Content of Return Value
Classification (including title, status, manager, owner) Display return value.
Numerical Value (including work volume, progression rate, remaining work volume) Do not display.
Date (including start and completion) Display return value. If the editor format is "Date and time (minutes)" or "Date and time (seconds)", 00:00:00 will be automatically completed.
Description (including content) Display return value.
Check (including lock) Do not display.

Usage Example ①

Specify parameters by screen column name (name displayed)

Formula

image

Parameters

image

Calculation Result

image

このページをシェアする
記載された商品名、各製品名は各社の登録商標または商標です。 © Implem Inc.