CHINESEDATEPRO

Converts a date into Lunar (Chinese) date. This is the advanced version of the CHINESEDATE function, which more parameter controls.

The Lunar Calendar is the way of calculating dates by Chines. It is still very commonly used nowadays. Therefore this function is a very useful tool to convert dates into Lunar dates.

Syntax

CHINESEDATEPRO(curDate, english_or_chinese, year_convention, month_convention, output_zodiac, output_YearOnly)

curDate the date to be converted into Lunar (Chinese) date.
english_or_chinese Optional. Either 1 or 2. 1 means the date output will be in English. 2 means the date output will be in Chinese. Default is 1, if omitted.
year_convention Optional. Either 1 or 2. Affects only Chinese date output.
1 means in numeric year format.
2 means the traditional Tiangan (Celestial stem) & Dizhi (Earthly Branches ) () format.
Default is 1, if omitted.
month_convention Optional. Either 1 or 2. Affects only Chinese date output.
1 means in numeric year format.
2 means in the old Chinese style of quoting months: “
Default is 1, if omitted.
output_zodiac Optional. Boolean argument, either TRUE or FALSE.
If TRUE, the output will contain the Zodiac animal as well.
Default is FALSE, if omitted.
output_YearOnly Optional. Boolean argument, either TRUE or FALSE.
If TRUE, the output will only contain the Year of the Lunar date.
Default is FALSE, if omitted.

Example

If today is 18 Apr 2013,

CHINESEDATEPRO(NOW(), 1) returns 9 Mar 2013
CHINESEDATEPRO(NOW(), 1) returns 9 Mar 2013
CHINESEDATEPRO(NOW(),,,,,TRUE) returns 2013
CHINESEDATEPRO(NOW(),1,1,1,TRUE) returns 2013 (Snake) March 9
CHINESEDATEPRO(NOW(),1,1,2,TRUE) returns 2013 (Snake) Peach 9
CHINESEDATEPRO(NOW(), 2, 1) returns
CHINESEDATEPRO(NOW(), 2, 2) returns

Note:

See Also:

CHINESEDATE
ZODIAC