ZODIAC

Returns the (Chinese) Zodiac animal of a date.

Syntax

ZODIAC(curDate, english_or_chinese)

curDate - the date to be converted into Zodiac.
english_or_chinese - Optional. Either 1 or 2. 1 means the output will be in English. 2 means the output will be in Chinese. Default is 1, if omitted.

Example

If today is 18 April 2013,

ZODIAC(NOW()) returns Snake.
ZODIAC(NOW()) returns

Note: