{"id":4162,"date":"2022-02-25T15:37:46","date_gmt":"2022-02-25T07:37:46","guid":{"rendered":"https:\/\/owa.sodexo-cn.com\/blog\/?p=4162"},"modified":"2022-02-25T15:37:46","modified_gmt":"2022-02-25T07:37:46","slug":"introduces-two-functions-hidden-in-excel","status":"publish","type":"post","link":"https:\/\/owa.sodexo-cn.com\/blog\/?p=4162","title":{"rendered":"Introduces two functions hidden in Excel"},"content":{"rendered":"\n<p>In Excel, there are several hidden functions. They can implement some useful functions which the existing formulas cannot implement. Today I will introduce you two useful hidden functions.<\/p>\n\n\n\n<p>Numberstring Function<br>Datedif Function<\/p>\n\n\n\n<h4 class=\"wp-block-heading\">Numberstring\uff1aConvert numbers into Chinese characters<\/h4>\n\n\n\n<p>This function has two arguments<br>First argument: The number you want to convert<br>Second argument: Specifies the type to return. 1 for Chinese character lowercase, 2 for Chinese character uppercase, 3 for Chinese character reading<br>If the number has a decimal, the function will covert it after rounding.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"427\" height=\"154\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2022\/02\/261.jpg\" alt=\"\" class=\"wp-image-4157\"\/><\/figure>\n\n\n\n<h4 class=\"wp-block-heading\">Datedif: Calculate the difference between the two dates<\/h4>\n\n\n\n<p>This function has three arguments<br>The first argument is the start date<br>The second argument is the end date<br>The third argument is to specify the return type<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"446\" height=\"204\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2022\/02\/262.jpg\" alt=\"\" class=\"wp-image-4158\"\/><\/figure>\n\n\n\n<p>As shown below, the length of service is calculated according to the employee&#8217;s entry date.<br>Y indicates the number of years in the calculation period. It is often used to calculate the length of service of an employee. If you want to calculate the number of months between two dates, replace the third argument with M.<\/p>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"554\" height=\"288\" src=\"https:\/\/owa.sodexo-cn.com\/blog\/wp-content\/uploads\/2022\/02\/263.jpg\" alt=\"\" class=\"wp-image-4159\"\/><\/figure>\n\n\n\n<p>That\u2019s all for today, Have a great weekend!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In Excel, there are several hidden functions. They can  &#8230; <a title=\"Introduces two functions hidden in Excel\" class=\"read-more\" href=\"https:\/\/owa.sodexo-cn.com\/blog\/?p=4162\" aria-label=\"\u9605\u8bfb Introduces two functions hidden in Excel\">\u9605\u8bfb\u66f4\u591a<\/a><\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-4162","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"views":1711,"_links":{"self":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4162","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4162"}],"version-history":[{"count":3,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4162\/revisions"}],"predecessor-version":[{"id":4166,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=\/wp\/v2\/posts\/4162\/revisions\/4166"}],"wp:attachment":[{"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4162"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4162"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/owa.sodexo-cn.com\/blog\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4162"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}