Difference between revisions of "Documentation/How Tos/Calc: EDATE function"
From Apache OpenOffice Wiki
< Documentation | How Tos
(Initial content) |
m (→See also:) |
||
| Line 20: | Line 20: | ||
=== See also: === | === See also: === | ||
| − | '''[[Documentation/How_Tos/Calc: DATE function|DATE]]''' | + | '''[[Documentation/How_Tos/Calc: DATE function|DATE]]''', |
| + | '''[[Documentation/How_Tos/Calc: WORKDAY function|WORKDAY]]''' | ||
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | '''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]''' | ||
Revision as of 21:08, 30 December 2007
EDATE
Returns a date a number of months away.
This function is only available if the Analysis AddIn is installed.
Syntax:
EDATE(startdate; months)
- months is a number of months that are added to the startdate. The day of the month remains unchanged, unless it is more than the number of days in the new month (when it becomes the last day of that month).
- months may be negative.
Example:
EDATE("2008/10/15"; 2)
- returns 15Dec08.
EDATE("2008/05/31"; -1)
- returns 30Apr08. There are only 30 days in April.
See also:
Issues:
EDATE returns a date-time serial number, which must be manually formatted to display as a date. This complies with the ODFF standard.
