The TYPE function returns a numeric code: If TYPE is given an array constant, or a range, the result is 64: TYPE returns 16 for errors:


You can’t use TYPE to test for a formula, because TYPE evaluates the result. Excel dates and times are numbers, and therefore return 1.

Dave Bruns

Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.