- Document Solutions for Excel, .NET Edition Overview
- Key Features
- Getting Started
- Features
- Templates
- Formula Reference
- File Operations
- Document Solutions Data Viewer
- API Reference
- Release Notes
EOMONTH
This function calculates the date for the last day of the month (end of the month) which is the indicated number of months before or after the starting date.
Syntax
EOMONTH(startdate, months)
Arguments
This function has these arguments:
Argument | Description |
|---|---|
startdate | [Required] The starting date, specified as a serial number, string, or DateTime object. |
months | [Required] Number of months before (negative) or after (positive) the starting date; if not an integer, the number is truncated. |
Specify the date argument as a number (as in 37806.5), a string (as in "7/4/2003 12:00"), or a DateTime object, as in DATE(2003,7,4).
Examples
EOMONTH(A3,6)
EOMONTH(R3C1,-4)
EOMONTH("2004/01/09",2) gives the result 38077