EDATE

From 6d54c8ef6cc5cde5ad48534ef395b42478729371 Mon Sep 17 00:00:00 2001 From: Rüdiger Timm Date: Fri, 26 Nov 2004 15:17:56 +0000 Subject: INTEGRATION: CWS helpcontentbeta (1.1.2); FILE MERGED 2004/09/16 11:46:18 fpe 1.1.2.1: Regular Update --- helpcontent2/source/text/scalc/01/func_edate.xhp | 58 +++++++++++----------- helpcontent2/source/text/scalc/01/func_eomonth.xhp | 58 +++++++++++----------- helpcontent2/source/text/scalc/01/func_hour.xhp | 56 ++++++++++----------- helpcontent2/source/text/scalc/01/func_minute.xhp | 54 ++++++++++---------- helpcontent2/source/text/scalc/01/func_month.xhp | 52 +++++++++---------- 5 files changed, 139 insertions(+), 139 deletions(-) diff --git a/helpcontent2/source/text/scalc/01/func_edate.xhp b/helpcontent2/source/text/scalc/01/func_edate.xhp index 50329c45f5..1d94984b14 100644 --- a/helpcontent2/source/text/scalc/01/func_edate.xhp +++ b/helpcontent2/source/text/scalc/01/func_edate.xhp @@ -1,4 +1,4 @@ - + - - - - -EDATE -text/scalc/01/func_edate.xhp - - - - - - + ************************************************************************--> + + + + +EDATE +text/scalc/01/func_edate.xhp + + + + + + EDATE function - + EDATE - -

-The result is a date which is a number of Months away from the Start date. Only months are considered; days are not used for calculation. -Syntax -EDATE(Start date;Months) - -Start date: a date. - -Months: the number of months. -Example -What date is one month prior to 3.31.2001? -=EDATE("3.31.2001";-1) returns 2.28.2001. - - + +

+The result is a date which is a number of Months away from the Start date. Only months are considered; days are not used for calculation. +Syntax +EDATE(Start date;Months) + +Start date: a date. + +Months: the number of months. +Example +What date is one month prior to 3.31.2001? +=EDATE("3.31.2001";-1) returns 2.28.2001. + + diff --git a/helpcontent2/source/text/scalc/01/func_eomonth.xhp b/helpcontent2/source/text/scalc/01/func_eomonth.xhp index 9d23bbfd8c..c1b99d0b7b 100644 --- a/helpcontent2/source/text/scalc/01/func_eomonth.xhp +++ b/helpcontent2/source/text/scalc/01/func_eomonth.xhp @@ -1,4 +1,4 @@ - + - - - - -EOMONTH -text/scalc/01/func_eomonth.xhp - - - - - - + ************************************************************************--> + + + + +EOMONTH +text/scalc/01/func_eomonth.xhp + + + + + + EOMONTH function - + EOMONTH - -

-Returns the date of the last day of a month which falls Months away from the Start date. -Syntax -EOMONTH (Start date; Months) - -Start date: calculated from this point onwards. - -Months: the number of months before (negative) or after (positive) the Start Date. -Example -What is the last day of the month that falls 6 months after September 14 2001? -=EOMONTH("9.14.2001";6) returns 3.31.2002. - - + +

+Returns the date of the last day of a month which falls Months away from the Start date. +Syntax +EOMONTH (Start date; Months) + +Start date: calculated from this point onwards. + +Months: the number of months before (negative) or after (positive) the Start Date. +Example +What is the last day of the month that falls 6 months after September 14 2001? +=EOMONTH("9.14.2001";6) returns 3.31.2002. + + diff --git a/helpcontent2/source/text/scalc/01/func_hour.xhp b/helpcontent2/source/text/scalc/01/func_hour.xhp index b49337518a..8569370a60 100644 --- a/helpcontent2/source/text/scalc/01/func_hour.xhp +++ b/helpcontent2/source/text/scalc/01/func_hour.xhp @@ -1,4 +1,4 @@ - + - - - - -HOUR -text/scalc/01/func_hour.xhp - - - - - - + ************************************************************************--> + + + + +HOUR +text/scalc/01/func_hour.xhp + + + + + + HOUR function - + HOUR - -Returns the hour for a given time value. The hour is returned as an integer between 0 and 23. -Syntax -HOUR(Number) - -Number, as a time value, is a decimal, for which the hour is to be returned. -Examples -HOUR(NOW()) returns the current hour -HOUR(C4) returns 17 if the contents of C4 = 17:20:00. -

-YEAR, NOW, MINUTE, MONTH, DAY, WEEKDAY. - - + +Returns the hour for a given time value. The hour is returned as an integer between 0 and 23. +Syntax +HOUR(Number) + +Number, as a time value, is a decimal, for which the hour is to be returned. +Examples +HOUR(NOW()) returns the current hour +HOUR(C4) returns 17 if the contents of C4 = 17:20:00. +

+YEAR, NOW, MINUTE, MONTH, DAY, WEEKDAY. + + diff --git a/helpcontent2/source/text/scalc/01/func_minute.xhp b/helpcontent2/source/text/scalc/01/func_minute.xhp index de986e548c..9e355805f4 100644 --- a/helpcontent2/source/text/scalc/01/func_minute.xhp +++ b/helpcontent2/source/text/scalc/01/func_minute.xhp @@ -1,4 +1,4 @@ - + - - - - -MINUTE -text/scalc/01/func_minute.xhp - - - - - - + ************************************************************************--> + + + + +MINUTE +text/scalc/01/func_minute.xhp + + + + + + MINUTE function - + MINUTE - -Calculates the minute for an internal time value The minute is returned as a number between 0 and 59. -Syntax -MINUTE(number) - -Number, as a time value, is a decimal number where the number of the minute is to be returned. -Examples -MINUTE(8.999) returns 58 -MINUTE(8.9999) returns 59 -MINUTE(NOW()) returns the current minute value. - - + +Calculates the minute for an internal time value The minute is returned as a number between 0 and 59. +Syntax +MINUTE(number) + +Number, as a time value, is a decimal number where the number of the minute is to be returned. +Examples +MINUTE(8.999) returns 58 +MINUTE(8.9999) returns 59 +MINUTE(NOW()) returns the current minute value. + + diff --git a/helpcontent2/source/text/scalc/01/func_month.xhp b/helpcontent2/source/text/scalc/01/func_month.xhp index 978d63ce40..be6ef393e7 100644 --- a/helpcontent2/source/text/scalc/01/func_month.xhp +++ b/helpcontent2/source/text/scalc/01/func_month.xhp @@ -1,4 +1,4 @@ - + - - - - -MONTH -text/scalc/01/func_month.xhp - - - - - - + ************************************************************************--> + + + + +MONTH +text/scalc/01/func_month.xhp + + + + + + MONTH function - + MONTH - -Returns the month for the given date value. The month is returned as an integer between 1 and 12. -Syntax -MONTH(Number) - -Number, as a time value, is a decimal for which the month is to be returned. -Examples -MONTH(NOW()) returns the current month -MONTH(C4) returns 7 if contents of C4 = 7/7/00. - - + +Returns the month for the given date value. The month is returned as an integer between 1 and 12. +Syntax +MONTH(Number) + +Number, as a time value, is a decimal for which the month is to be returned. +Examples +MONTH(NOW()) returns the current month +MONTH(C4) returns 7 if contents of C4 = 7/7/00. + + -- cgit