MONTHDELTA- FineBI Help Document

Last update：March 12, 2025

Overview

Syntax	Parameter
MONTHDELTA(date,delta)	delta
This function returns the date several months (specified by delta) after the specified date.	Besides the text and date types, the date parameter can also be of the serial number type in the 1900 date system for extracted data. For example, the serial number 35796 represents 1998-01-01. Note: The date parameter can only be of the text or date type for real-time data.

Syntax

Parameter

MONTHDELTA(date,delta)

delta

This function returns the date several months (specified by delta) after the specified date.

Besides the text and date types, the date parameter can also be of the serial number type in the 1900 date system for extracted data. For example, the serial number 35796 represents 1998-01-01.

Note:

The date parameter can only be of the text or date type for real-time data.

Notes

The function supports two parameters, with the first being a date or text parameter, and the second being a numeric parameter.

Example

Formula	Result	Note
MONTHDELTA("2008-08-08",4)	2008-12-08
MONTHDELTA(35796,4)	1998-05-01	Such syntax is not supported for real-time data.

Helpful
Not helpful
Only read

中文（简体）中文（繁體）日本語

English

MONTHDELTA

Overview

Notes

Example

附件列表