Spreadsheets support many different formats for dates and allow users to specify custom formats. When working with ranges, the Cube Spreadsheet App recognizes dates with any of the formats listed in this article.
When working with table ranges, all headers, including dates, must be formatted as text.
Not sure how to set the format for a cell? See Microsoft's Excel or Google's Sheets formatting instructions for help.
Range supported date formats
The Spreadsheet App supports the following formats for ranges.
Day, month, and year formats
| Format | Example for February 4, 2022 |
| d/m/yyyy | 4/2/2022 |
| d/m/yy | 4/2/22 |
| d-m-yyyy | 4-2-2022 |
| d-m-yy | 4-2-22 |
| dd/m/yyyy | 04/2/2022 |
| dd/m/yy | 04/2/22 |
| dd-m-yyyy | 04-2-2022 |
| dd-m-yy | 04-2-22 |
| d/mm/yyyy | 4/02/2022 |
| d/mm/yy | 4/02/22 |
| d-mm-yyyy | 4-02-2022 |
| d-mm-yy | 4-02-22 |
| dd/mm/yyyy | 04/02/2022 |
| dd/mm/yy | 04/02/22 |
| dd-mm-yyyy | 04-02-2022 |
| dd-mm-yy | 04-02-22 |
Day and month formats
| Format | Example for February 4, 2022 |
| d-mmm | 4-Feb |
Month, day and year formats
| Format | Example for February 4, 2022 |
| mm / dd / yyyy | 02 / 04 / 2022 |
| mm/dd/yy | 02/04/22 |
| mm-dd-yyyy | 02-04-2022 |
| mm-dd-yy | 02-04-22 |
| mm.dd.yyyy | 02.04.2022 |
| mm.dd.yy | 02.04.22 |
| mm dd yyyy | 02 04 2022 |
| mm dd yy | 02 04 22 |
| m/d/yyyy | 2/4/2022 |
| m/d/yy | 2/4/22 |
| m-dd-yyyy | 2-04-2022 |
| m-dd-yy | 2-04-22 |
| m.dd.yyyy | 2.04.2022 |
| m.dd.yy | 2.04.22 |
| m dd yyyy | 2 04 2022 |
| m dd yy | 2 04 22 |
| mmm/dd/yyyy | Feb/04/2022 |
| mmm/dd/yy | Feb/04/22 |
| mmm-dd-yyyy | Feb-04-2022 |
| mmm-dd-yy | Feb-04-22 |
| mmm.dd.yyyy | Feb.04.2022 |
| mmm.dd.yy | Feb.04.22 |
| mmm dd yyyy | Feb 04 2022 |
| mmm dd yy | Feb 04 22 |
Month and year formats
| Format | Example for February 4, 2022 |
| mmm-yy | Feb-22 |
| mm/yyyy | 02/2022 |
| mm/yy | 02/22 |
| mm-yyyy | 02-2022 |
| mm-yy | 02-22 |
| mm.yyyy | 02.2022 |
| mm.yy | 02.22 |
| mm yyyy | 02 2022 |
| mm yy | 02 22 |
| m/yyyy | 2/2022 |
| m/yy | 2/22 |
| m-yyyy | 2-2022 |
| m-yy | 2-22 |
| m.yyyy | 2.2022 |
| m.yy | 2.22 |
| m yyyy | 2 2022 |
| m yy | 2 22 |
| mmm/yyyy | Feb/2022 |
| mmm/yy | Feb/22 |
| mmm-yyyy | Feb-2022 |
| mmm-yy | Feb-22 |
| mmm.yyyy | Feb.2022 |
| mmm.yy | Feb.22 |
| mmm yyyy | Feb 2022 |
| mmm yy | Feb 22 |
Year formats
| Format | Example for February 4, 2022 |
| yyyy | 2022 |
| yy | 22 |