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.
Numberstring Function
Datedif Function
Numberstring：Convert numbers into Chinese characters
This function has two arguments
First argument: The number you want to convert
Second argument: Specifies the type to return. 1 for Chinese character lowercase, 2 for Chinese character uppercase, 3 for Chinese character reading
If the number has a decimal, the function will covert it after rounding.
Datedif: Calculate the difference between the two dates
This function has three arguments
The first argument is the start date
The second argument is the end date
The third argument is to specify the return type
As shown below, the length of service is calculated according to the employee’s entry date.
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.
That’s all for today, Have a great weekend!