DATE Function in Apple Numbers: Syntax, Examples and Troubleshooting

DATE(year, month, day) constructs a date/time value from three numeric arguments in that order. For example, =DATE(2024,2,29) has the expected calendar value 29 February 2024 (a leap day), displayed according to the cell’s date format.

Build a real date from separate year, month and day numbers. Use it to avoid importing locale-ambiguous date strings. Use a real date/time input whenever possible. Unlike text manipulation, these date functions work with calendar dates and can be copied down a Numbers table.

=DATE(year, month, day)

Apple’s official DATE help documents the required argument order, the accepted input type and the defined result (checked 2026-10-11, documentation path 15.4). There are no optional arguments in this documented signature. Avoid treating a versioned help URL as proof of the first app release supporting the function.

Create a table named Milestones. Label row 1 with Year, Month, Day, Event date, Day no., Month no., and Year no. in columns A–G. Enter these numbers, not typed date strings, into A–C:

In D2 enter =DATE(A2,B2,C2) and fill down to D5. Set D2:D5 to a Date & Time display format if needed; the rendered words/order may differ with the device’s regional settings. The table reports expected calendar dates, not screenshots or observed executions. In E2 enter =DAY(D2), in F2 =MONTH(D2), and in G2 =YEAR(D2); fill each down to row 5. All four outputs were independently checked against the input calendar dates, not in Apple Numbers.

1. Create the Milestones table shown above and enter the year, month and day as numeric cells.
2. In D2, type =DATE(A2,B2,C2) and fill it down to D5.
3. The independently checked expected D2–D5 calendar dates are 29 Feb 2024, 31 Dec 2025, 11 Oct 2026, and 5 Jan 2020. If D2 displays an unexpected numerical representation, change its cell display to a date format; do not change the formula to a typed string.
4. Verify the leap-day row: =DATE(2024,2,29) represents a valid 2024 leap date. A 2025 February 29 is not a valid day for that month according to Apple’s specified day range; do not assume it will silently roll over.
5. The literal =DATE(2026,10,11) should represent 11 October 2026 irrespective of whether the user interface displays 10/11/2026 or 11/10/2026.

Normalize an event date to the first of its calendar month

If D2 contains a valid Numbers date value from the table, put =DATE(YEAR(D2),MONTH(D2),1) in H2. The independently calculated expected result for D2 is 1 February 2024; for D3 it is 1 December 2025. This is useful for grouping billing or inventory records by reporting month without manipulating locale-sensitive text. YEAR and MONTH are distinct documented functions, and the sample only assumes a real date/time input.

Recombine a year and month from a category table

If A2 is 2024 and B2 is 2, =DATE(A2,B2,1) yields the expected 1 February 2024. Prefer full four-digit years in operational data to avoid accidental cross-software year interpretation.

• Month 0 or 13: Apple’s definition specifies months 1–12. Fix the input rather than relying on Excel/Sheets overflow normalization; the exact Numbers error message was not observed.
• Invalid day: 29 February 2025 and 31 April 2026 violate the documented day range. Check the month length and leap-year rules; no specific Numbers error code is asserted.
• Reversed year/month/day order: =DATE(A2,C2,B2) would use day as month, potentially invalid or a different date. Apple’s order is year, month, day.
• Two-digit years: Apple says DATE(10,1,1) uses year 10. It does not automatically infer 2010; always store full four-digit years.
• Unexpected display: A correct date/time value can be shown in different visual formats. Fix the cell’s date formatting before rewriting a working formula.
• Text instead of numeric input: validate input cell types; Apple documents the three DATE arguments as number values. Do not assume that imported strings are safely interpreted identically everywhere.

Excel and Google Sheets also offer DATE(year,month,day), but identical syntax is not a guarantee of identical behavior for unusual years, invalid dates or serial values. Apple explicitly says a small year (for example 10) remains that year; Excel’s common 1900-based system interprets many low year numbers differently. Microsoft also documents both 1900 and 1904 date serial systems, so avoid directly comparing imported raw date serials without conversion. Prefer real calendar-date inputs and validate edge cases separately in each app. This guide does not claim an Excel or Google Sheets formula was executed.

• In the same Numbers table, A2, D2, and D2:D5 are appropriate relative references. Other-table references may require Milestones::D2 or a sheet-qualified Sheet Name::Milestones::D2; click the cell in Numbers’ formula editor rather than copying Excel sheet-reference syntax. Apple’s cell-reference guide is the reference for this distinction.
• Apple’s English Functions Help writes arguments separated by commas. If the device uses a comma decimal separator, Apple says to type semicolons between function arguments. The separator rule affects multiple-argument functions such as DATE; unary functions have no separator to change. See Apple’s Functions Overview.
• The page is based on Apple’s Formulas and Functions Help documentation path 15.4, checked 2026-10-11. It does not establish when the function was introduced in the Numbers app. Apple’s Help welcome describes the function browser in Numbers on Mac, iPhone, iPad and iCloud.com, but this page does not certify identical behavior across all past macOS, iOS, iPadOS or browser versions. No native execution was performed on any of those platforms.
• Avoid ambiguous typed date strings such as 04/06/2024 when sharing across locales. A calendar date constructed from numeric year/month/day with DATE is clearer. Display formatting does not change the meaning of DAY, MONTH or YEAR on an actual date/time value.

• COUNTIFS in Apple Numbers — count records matching date-related conditions after validating that the date cells contain dates.
• SUMIFS in Apple Numbers — aggregate amounts by reporting periods when the data and criteria are appropriate.

DATE, DATE, DAY, MONTH, and YEAR are now part of the same Numbers function library. See DATE, DAY, MONTH, and YEAR for individual explanations. Native Numbers execution has not been recorded for these examples.

• Apple Numbers — function documentation
• Apple’s cell-reference guide
• Apple’s Functions Overview
• Help welcome

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.