Guide to Formatting Dates in the Cube Add-on – Cube

Cells in a spreadsheet have a Format that determines how the value is displayed and interpreted. Spreadsheets support many different formats for dates and allow users to specify custom formats. The Cube Add-on recognizes dates with any of the formats listed in this article.

Not sure how to set the format for a cell? See Microsoft's Excel or Google's Sheets formatting instructions for help.

Supported date formats

The following formats are supported by the Cube Add-on.

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

Related to