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.