IMSECH Function Explained
The IMSECH
Function in Microsoft Excel is used to calculate the Imperial Chinese Sexagenary Cycle for a given date. It takes two arguments: a date in the form of a serial number, and a return type which can be either 1
or 2
. If the return type is 1
, the function will return the Heavenly Stem of the date; if the return type is 2
, the function will return the Earthly Branch of the date.
IMSECH Function Syntax
IMSECH(text, character_num, occurrence_num)
- text: The text string from which you want to extract a specific character.
- character_num: The position of the character in the text string you want to extract.
- occurrence_num: The occurrence of the character in the text string you want to extract.