EASTERSUNDAY

์ž…๋ ฅํ•œ ์—ฐ๋„์˜ ๋ถ€ํ™œ ์ฃผ์ผ ๋‚ ์งœ๋ฅผ ๊ตฌํ•ฉ๋‹ˆ๋‹ค.

Syntax

EASTERSUNDAY(๋…„)

๋…„์€ 1583๊ณผ 9957 ๋˜๋Š” 0 ๊ณผ 99 ์‚ฌ์ด์˜ ์ •์ˆ˜์ž…๋‹ˆ๋‹ค. ๋˜ํ•œ ์ด ๋‚ ์งœ์— ๊ฐ„๋‹จํ•œ ๋ง์…ˆ์œผ๋กœ ๋‹ค๋ฅธ ๊ณตํœด์ผ์„ ๊ณ„์‚ฐํ•  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค.

๋ถ€ํ™œ์ ˆ ์›”์š”์ผ = EASTERSUNDAY(๋…„) + 1

์„ฑ๊ธˆ์š”์ผ = EASTERSUNDAY(๋…„) - 2

์„ฑ๋ น ๊ฐ•๋ฆผ์ œ ์ผ์š”์ผ = EASTERSUNDAY(๋…„) + 49

์„ฑ๋ น ๊ฐ•๋ฆผ์ œ ์›”์š”์ผ = EASTERSUNDAY(๋…„) + 50

Example

=EASTERSUNDAY(2000) returns 2000-04-23.

=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.

Date & Time Functions

DATE

[text/scalc/01/func_datedif.xhp#datedif not found].

DATEVALUE

DAY

DAYS

DAYS360

EASTERSUNDAY

EDATE

EOMONTH

HOUR

[text/scalc/01/func_isoweeknum.xhp#isoweeknum not found].

MINUTE

MONTH

NETWORKDAYS

NETWORKDAYS.INTL

NOW

SECOND

TIME

TIMEVALUE

TODAY

WEEKDAY

WEEKNUM

WEEKNUM_ADD

[text/scalc/01/func_weeknum_ooo.xhp#weeknum_ooo not found].

WORKDAY

WORKDAY.INTL

YEAR

YEARFRAC

Please support us!