DATE

Creates a valid Excel date from individual numbers.

The DATE function is the primary tool for constructing a valid Excel serial date from separate year, month, and day integers. It is essential for ensuring date consistency across different regional settings, as it avoids the ambiguity of text-based date entry (e.g., 01/02/2023 being read as January 2nd or February 1st). A powerful technical feature of DATE is its ability to handle 'overflow' and 'underflow' automatically; for instance, supplying 13 for the month will roll over to January of the following year, and supplying 0 for the day returns the last day of the previous month. This makes it ideal for complex date arithmetic. Best practices include using four-digit years to avoid ambiguity, as Excel interprets years 0-1899 by adding 1900 to the value. Users should note that the function returns a serial number; if the result appears as a raw number like 45134, you must apply a Date format to the cell to display it correctly.