Difference between revisions of "Documentation/How Tos/Calc: EDATE function"

From Apache OpenOffice Wiki
Jump to: navigation, search
(Initial content)
 
(10 intermediate revisions by 4 users not shown)
Line 1: Line 1:
−
__NOTOC__
+
{{Documentation/MasterTOC
 +
|bookid=1234'''
 +
|booktitle=<div style="padding: 8px; font-size: 140%; font-weight: bold; background-color: #9BC0F5;">CALC FUNCTIONS</div>
 +
|ShowParttitle=block|parttitle=[[Documentation/How_Tos/Calc:_Date_%26_Time_functions|<div  style="font-size: 140%;">Date & Time Functions]]
 +
|ShowNextPage=block|NextPage=Documentation/How_Tos/Calc:_WORKDAY_function
 +
|ShowPrevPage=block|PrevPage=Documentation/How_Tos/Calc:_EOMONTH_function
 +
|ShowPrevPart=block|PrevPart=Documentation/How_Tos/Calc:_Database_functions
 +
|ShowNextPart=block|NextPart=Documentation/How_Tos/Calc:_Financial_functions
 +
|toccontent= <div style="padding: 4px; font-size: 130%; font-weight: hidden; background-color:#DCE9FC;">FUNCTIONS</div>
 +
* [[Documentation/How_Tos/Calc:_TODAY_function|<div style="font-size: 120%;">Today]]
 +
* [[Documentation/How_Tos/Calc:_NOW_function|<div style="font-size: 120%;">Now]]
 +
* [[Documentation/How_Tos/Calc:_YEAR_function|<div style="font-size: 120%;">Year]]
 +
* [[Documentation/How_Tos/Calc:_MONTH_function|<div style="font-size: 120%;">Month]]
 +
* [[Documentation/How_Tos/Calc:_DAY_function|<div style="font-size: 120%;">Day]]
 +
* [[Documentation/How_Tos/Calc:_WEEKDAY_function|<div style="font-size: 120%;">Weekday]]
 +
* [[Documentation/How_Tos/Calc:_HOUR_function|<div style="font-size: 120%;">Hour]]
 +
* [[Documentation/How_Tos/Calc:_MINUTE_function|<div style="font-size: 120%;">Minute]]
 +
* [[Documentation/How_Tos/Calc:_SECOND_function|<div style="font-size: 120%;">Second]]
 +
* [[Documentation/How_Tos/Calc:_DATE_function|<div style="font-size: 120%;">Date]]
 +
* [[Documentation/How_Tos/Calc:_DATEVALUE_function|<div style="font-size: 120%;">Datevalue]]
 +
* [[Documentation/How_Tos/Calc:_TIME_function|<div style="font-size: 120%;">Time]]
 +
* [[Documentation/How_Tos/Calc:_TIMEVALUE_function|<div style="font-size: 120%;">Timevalue]]
 +
* [[Documentation/How_Tos/Calc:_EOMONTH_function|<div style="font-size: 120%;">Eomonth]]
 +
* [[Documentation/How_Tos/Calc:_EDATE_function|<div style="font-size: 120%; border-style: double; border-color:#778899;">Edate]]
 +
* [[Documentation/How_Tos/Calc:_WORKDAY_function|<div style="font-size: 120%;">Workday]]
 +
* [[Documentation/How_Tos/Calc:_NETWORKDAYS_function|<div style="font-size: 120%;">Networkdays]]
 +
* [[Documentation/How_Tos/Calc:_DAYS_function|<div style="font-size: 120%;">Days]]
 +
* [[Documentation/How_Tos/Calc:_DAYS360_function|<div style="font-size: 120%;">Days360]]
 +
* [[Documentation/How_Tos/Calc:_DAYSINMONTH_function|<div style="font-size: 120%;">Daysinmonth]]
 +
* [[Documentation/How_Tos/Calc:_DAYSINYEAR_function|<div style="font-size: 120%;">Daysinyear]]
 +
* [[Documentation/How_Tos/Calc:_WEEKS_function|<div style="font-size: 120%;">Weeks]]
 +
* [[Documentation/How_Tos/Calc:_WEEKSINYEAR_function|<div style="font-size: 120%;">Weeksinyear]]
 +
* [[Documentation/How_Tos/Calc:_WEEKNUM_function|<div style="font-size: 120%;">Weeknum]]
 +
* [[Documentation/How_Tos/Calc:_WEEKNUM_ADD_function|<div style="font-size: 120%;">Weeknum_add]]
 +
* [[Documentation/How_Tos/Calc:_MONTHS_function|<div style="font-size: 120%;">Months]]
 +
* [[Documentation/How_Tos/Calc:_YEARS_function|<div style="font-size: 120%;">Years]]
 +
* [[Documentation/How_Tos/Calc:_ISLEAPYEAR_function|<div style="font-size: 120%;">Isleapyear]]
 +
* [[Documentation/How_Tos/Calc:_EASTERSUNDAY_function|<div style="font-size: 120%;">Eastersunday]]
 +
* [[Documentation/How_Tos/Calc:_YEARFRAC_function|<div style="font-size: 120%;">Yearfrac]]
 +
}}__TOC__
  
 
== EDATE ==
 
== EDATE ==
Line 13: Line 52:
  
 
=== Example: ===
 
=== Example: ===
−
<tt>'''EDATE("2008/10/15"; 2)'''</tt>
+
<tt>'''EDATE("2008-10-15"; 2)'''</tt>
 
: returns 15Dec08.
 
: returns 15Dec08.
  
−
<tt>'''EDATE("2008/05/31"; -1)'''</tt>
+
<tt>'''EDATE("2008-05-31"; -1)'''</tt>
 
: returns 30Apr08. There are only 30 days in April.
 
: returns 30Apr08. There are only 30 days in April.
  
−
=== See also: ===
+
=== Issues: ===
−
'''[[Documentation/How_Tos/Calc: DATE function|DATE]]'''
+
<tt>'''EDATE'''</tt> returns a date-time serial number, which must be manually formatted to display as a date. This complies with the ODFF standard.
  
−
'''[[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]'''
+
{{SeeAlso|EN|
 +
* [[Documentation/How_Tos/Calc: DATE function|DATE]]
 +
* [[Documentation/How_Tos/Calc: WORKDAY function|WORKDAY]]
  
−
'''[[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]'''
+
* [[Documentation/How_Tos/Calc: Date & Time functions#Date and Time overview|Date & Time overview]]
  
−
=== Issues: ===
+
* [[Documentation/How_Tos/Calc: Date & Time functions|Date & Time functions]]
−
<tt>'''EDATE'''</tt> returns a date-time serial number, which must be manually formatted to display as a date. This complies with the ODFF standard.
+
 
 +
* [[Documentation/How_Tos/Calc: Functions listed alphabetically|Functions listed alphabetically]]
 +
* [[Documentation/How_Tos/Calc: Functions listed by category|Functions listed by category]]}}
 +
[[Category: Documentation/Reference/Calc/Date and Time functions]]

Revision as of 07:25, 17 July 2018


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.

Issues:

EDATE returns a date-time serial number, which must be manually formatted to display as a date. This complies with the ODFF standard.


See Also
Retrieved from "https://wiki.openoffice.org/w/index.php?title=Documentation/How_Tos/Calc:_EDATE_function&oldid=243334"
Views
Personal tools
Navigation
Tools