1 <?xml version=
"1.0" encoding=
"UTF-8"?>
6 ***********************************************************************
8 * DO NOT ALTER OR REMOVE COPYRIGHT NOTICES OR THIS FILE HEADER.
10 * Copyright 2008 by Sun Microsystems, Inc.
12 * OpenOffice.org - a multi-platform office productivity suite
14 * $RCSfile: func_eastersunday.xhp,v $
17 * This file is part of OpenOffice.org.
19 * OpenOffice.org is free software: you can redistribute it and/or modify
20 * it under the terms of the GNU Lesser General Public License version 3
21 * only, as published by the Free Software Foundation.
23 * OpenOffice.org is distributed in the hope that it will be useful,
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
26 * GNU Lesser General Public License version 3 for more details
27 * (a copy is included in the LICENSE file that accompanied this code).
29 * You should have received a copy of the GNU Lesser General Public License
30 * version 3 along with OpenOffice.org. If not, see
31 * <http://www.openoffice.org/license.html>
32 * for a copy of the LGPLv3 License.
34 ************************************************************************
38 <helpdocument version=
"1.0">
40 <topic id=
"textscalc01func_eastersundayxml" indexer=
"include" status=
"PUBLISH">
41 <title id=
"tit" xml-lang=
"en-US">EASTERSUNDAY
</title>
42 <filename>/text/scalc/
01/func_eastersunday.xhp
</filename>
46 <bookmark xml-lang=
"en-US" branch=
"index" id=
"bm_id3152960"><bookmark_value>EASTERSUNDAY function
</bookmark_value>
48 <bookmark xml-lang=
"en-US" branch=
"hid/HID_FUNC_OSTERSONNTAG" id=
"bm_id3156270" localize=
"false"/><paragraph role=
"heading" id=
"hd_id3152960" xml-lang=
"en-US" level=
"2" l10n=
"U" oldref=
"175"><variable id=
"eastersunday"><link href=
"text/scalc/01/func_eastersunday.xhp">EASTERSUNDAY
</link>
49 </variable></paragraph>
50 <paragraph role=
"paragraph" id=
"par_id3154570" xml-lang=
"en-US" l10n=
"U" oldref=
"176"><ahelp hid=
"HID_FUNC_OSTERSONNTAG">Returns the date of Easter Sunday for the entered year.
</ahelp></paragraph>
51 <paragraph role=
"heading" id=
"hd_id9460127" xml-lang=
"en-US" level=
"3" l10n=
"NEW">Syntax
</paragraph>
52 <paragraph role=
"code" id=
"par_id2113711" xml-lang=
"en-US" l10n=
"NEW">EASTERSUNDAY(Year)
</paragraph>
53 <paragraph role=
"paragraph" id=
"par_id3938413" xml-lang=
"en-US" l10n=
"NEW">
54 <emph>Year
</emph> is an integer between
1583 and
9956 or
0 and
99. You can also calculate other holidays by simple addition with this date.
</paragraph>
55 <paragraph role=
"paragraph" id=
"par_id3156156" xml-lang=
"en-US" l10n=
"U" oldref=
"177">Easter Monday = EASTERSUNDAY(Year) +
1</paragraph>
56 <paragraph role=
"paragraph" id=
"par_id3147521" xml-lang=
"en-US" l10n=
"U" oldref=
"178">Good Friday = EASTERSUNDAY(Year) -
2</paragraph>
57 <paragraph role=
"paragraph" id=
"par_id3146072" xml-lang=
"en-US" l10n=
"U" oldref=
"179">Pentecost Sunday = EASTERSUNDAY(Year) +
49</paragraph>
58 <paragraph role=
"paragraph" id=
"par_id3149553" xml-lang=
"en-US" l10n=
"U" oldref=
"180">Pentecost Monday = EASTERSUNDAY(Year) +
50</paragraph>
59 <paragraph role=
"heading" id=
"hd_id3155120" xml-lang=
"en-US" level=
"3" l10n=
"U" oldref=
"181">Examples
</paragraph>
60 <paragraph role=
"paragraph" id=
"par_id3154472" xml-lang=
"en-US" l10n=
"CHG" oldref=
"182">=EASTERSUNDAY(
2000) returns
2000-
04-
23.
</paragraph>
61 <paragraph role=
"paragraph" id=
"par_id3150940" xml-lang=
"en-US" l10n=
"CHG" oldref=
"184">EASTERSUNDAY(
2000)+
49 returns the internal serial number
36688. The result is
2000-
06-
11. Format the serial date number as a date, for example in the format YYYY-MM-DD.
</paragraph>