ISNUMBERORDATE returns TRUE if an expression evaluates to either a number or a date, and FALSE otherwise. It is a broad type-screening test, not a way to assert that a date is a valid measurement.

Syntax: =ISNUMBERORDATE(cell) — a single required argument, in Apple’s current English Functions Help, edition 15.4. See Apple’s ISNUMBERORDATE function reference (accessed 2026-10-11). There are no additional documented optional arguments or defaults for this function.

Use it when an import column legitimately contains numeric measures and dates, or when triaging mixed records before routing them to separate calculations. In strictly numeric columns, use ISNUMBER instead.

The important distinction is stored/evaluated value type, not the visible formatting alone. An imported value may look like a number or date while being held as text. Apple describes separate number, string, Boolean and date/time types in its value-type reference.

=ISNUMBERORDATE(cell)

The placeholder cell is a descriptive argument name, not text to type literally. A working reference is B6, so a complete formula is =ISNUMBERORDATE(B6). Write = to start a formula. The single argument has no comma of its own; nested functions with multiple arguments use commas in Apple’s English examples, or semicolons when your decimal separator is a comma according to Apple’s Functions overview. For example, =IF(ISNUMBERORDATE(B6),"Yes","No") becomes =IF(ISNUMBERORDATE(B6);"Yes";"No") in that locale.

A quick independent check

B6 numeric 42 → expected TRUE; B7 date Feb 29, 2024 → expected TRUE; B5 text pending → expected FALSE.

Create a table called Intake Types with a header row. Column A is a human-readable case label, column B is the value under test, and column C will contain the test formula. Create the cells deliberately—automatic input recognition can otherwise change their types.

Do not paste the B column from this Markdown table as plain text and assume Numbers will create the intended types. The date and Boolean examples are formulas, the text ID needs deliberate formatting, and B2 must remain empty. The outputs below are expected/documentation-derived, not screenshots or measurements of a live Numbers session.

Enter the formula and inspect the expected outcomes

In C2 type =ISNUMBERORDATE(B2) and fill to C9. Expected TRUE values are C6, C7 and C9, corresponding to numeric 42, the date result, and numeric zero. Text 007, label pending, one space and logical TRUE are outside the two documented accepted value types.

Documented-type expected results for =ISNUMBERORDATE(B2) copied through C9:

These outcomes were checked against an independent Python type-model using explicit values (blank, text, numeric, date, Boolean). That is not native Numbers execution. Automatic import/conversion and special formula-return types still require a real Numbers app validation pass.

Route mixed input types without treating them as interchangeable

=IF(ISNUMBERORDATE(B7),"Number/date supplied","Other input") should return Number/date supplied for B7’s date value. This verifies that the value is one of two accepted types; it does not mean B7*0.05 is a meaningful price calculation. Use ISNUMBER before calculations intended strictly for numeric measurements.

Check a mixed export for nondata placeholders

Let B5 contain the string pending, B6 contain 42 and B7 contain a real date. =ISNUMBERORDATE(B5) is expected FALSE while B6 and B7 are expected TRUE. In a triage column, use =IF(ISNUMBERORDATE(B5),"Typed data","Check text") and copy down. This is a data-routing aid, not a substitute for schema checks on each field.

Why this is different from ISNUMBER

Apple lists separate ISNUMBER, ISDATE and ISNUMBERORDATE functions. A number-only validation and a number-or-date validation answer different questions. Keep them as separate guides and separate formulas; do not invent ISNUMBERORDATE as an alias of ISNUMBER.

• A date-like string returns FALSE: verify whether it is real date data rather than imported text. The documentation tests evaluated value type.
• A numeric-looking code returns FALSE: codes such as 007 preserved as text are not automatically numbers.
• A Boolean is unexpectedly accepted in another app: never infer cross-app Boolean coercion; Apple’s function definition names only number or date.
• You only need quantities: use ISNUMBER, not this broader predicate, so a date does not pass a numeric intake check.
• Errors and blank cells: investigate source formulas and whether the referenced cell actually contains data before treating FALSE as a missing-value signal.

For an initial diagnostic, try a simple function call using Apple’s examples before a complex nested expression. If a formula shows an error instead of a TRUE/FALSE result, investigate the source reference and formula syntax rather than treating the error as a Boolean FALSE. Apple has a separate error-review guide, also accessed 2026-10-11.

In the same table, use B6. Apple documents cross-table references such as Intake Types::B6 and cross-sheet references in the form Sheet 2::Intake Types::B6 when identification is needed. Selecting the cell in the Formula Editor is safer than manually guessing a qualified reference. Relative references move with copied formulas, while absolute references can be locked.

This guide follows the publicly accessible Apple Formulas and Functions Help 15.4 on 2026-10-11. The documentation also describes using the function browser in Numbers on Mac, iPhone and iPad and through iCloud.com; this does not independently establish the first Numbers app release or availability of every function on every historical platform. Native execution on Mac, iPhone/iPad and iCloud was not performed.

Apple explicitly documents ISNUMBERORDATE as one function. Microsoft’s Excel IS-function family does not include that identifier; Excel users must design a tested equivalent based on the actual date representation. Google Sheets’ function set and number/date storage also require separate comparison; a same-named function should never be assumed.

When transferring workbooks, test the actual input types, arguments, and output on the destination software; do not assume a successful import proves formula equivalence. For help on specific cross-app function families consult Microsoft’s IS functions and Google Sheets’ published function list.

Publication note: Related guide links should be checked in the generated site. Native Numbers execution is not recorded.

• Documentation inspection: https://support.apple.com/guide/functions/isnumberordate-ffadc1408a52/15.4/web/1.0, edition 15.4, read on 2026-10-11. The syntax, argument shape and function-level TRUE/FALSE rule come from that function page.
• Cell references and locales: Apple references and Functions overview, read 2026-10-11.
• Value types: Apple value types, read 2026-10-11.
• Independent calculation: a Python type-model computed the eight tabulated expected logical outcomes and asserted the row results. This is a separate model, not an observation from the Numbers engine.
• Coverage: This function was added after the earlier eight-page Numbers launch collection.

• Apple Numbers — function documentation
• value-type reference
• Apple’s Functions overview
• Apple references

Verification status: Official documentation checked; example outcomes were independently reasoned or arithmetically checked where applicable. Not executed in Apple Numbers.

• No genuine Apple Numbers screenshots are included; this guide does not use mock application images.