Other Functions
NETWORKDAYS(start_date, end_date, [holidays]): Returns the number of whole working days between start_date and end_date.
Example: =NETWORKDAYS(A1, B1) calculates the working days between the dates in A1 and B1.
RANK(number, ref, [order]): Returns the rank of a number in a list of numbers.
Example: =RANK(A1, A1:A10, 0) returns the rank of the number in A1 within the range A1:A10.
CHAR(number): Returns the character specified by a number.
Example: =CHAR(65) returns “A”.
CODE(text): Returns the numeric code for the first character in a text string.
Example: =CODE(“A”) returns 65.
For all things Strategy, Management Theories, and Business Frameworks, please visit https://www.stratrix.com