Functions in all categories share a common set of data types such as number, text, date and Boolean. Each function accepts one or more parameters of a given type and returns a value of a given type.

A new JavaScript API will be available to preview inside Excel later this month, which will let developers create these custom data types for inputs and outputs and enable custom functions.