Creating Date Cells
Overview
Date cells display date values. You can specify one of several date formats, as shown in the following figure.
You can set maximum and minimum values for the date values, and you can customize the available date formats.
For a description of how date cells validate data, see Data Validation.
In summary, you can use the following properties to customize date cells. The italicized properties are unique to this cell type. For more information on remembered properties, refer to Cell Type Settings Remembered.
TypeDateCentury | TypeDateSeparator | TypeTextOrient |
TypeDateFormat | TypeEllipses | TypeVAlign |
TypeDateMax | TypeHAlign | |
TypeDateMin | TypeSpin |