Calc Formatting Reference
Date Formats for custom date formatting
| Format |
Code |
| Day 1 character (1) |
D |
| Day 2 characters (01) |
DD |
| Day abbreviation (Mon) |
DDD |
| Day full name (Monday) |
DDDD |
| Day followed by a comma (Monday,) |
NNNN |
| Month 1 character (1) |
M |
| Month 2 characters (01) |
MM |
| Month abbreviation (Jan) |
MMM |
| Full month name(January) |
MMMM |
| Month first letter (J) |
MMMMM |
| Year 2 digits (15) |
YY |
| Year 4 digits (2015) |
YYYY |
| Week of the year (1-52) |
WW |
| Quarter 2 character (Q1) |
Q |
| Quarter full (1st Quarter) |
QQ |
When a 2 digit year is used dates entered into the cell of 1/1/30 or later will be considered in the 20th century 1/1/1930, dates with 2 digit years before 30 will be in the 21st century. 1/1/29 will be interpreted as 2029.
Time Codes
| Format |
Code |
| Hours 0-23 |
h |
| Hours 00-23 |
hh |
| Minutes 0-59 |
m |
| Minutes 00-59 |
mm |
| Seconds 0-59 |
s |
| Seconds 00-59 |
ss |
Date Codes for Different Locales
| Locale |
Year |
Month |
Day |
Hour |
Day of Week |
| English |
Y |
M |
D |
H |
N |
| German |
J |
M |
T |
H |
N |
| Netherlands |
J |
M |
D |
U |
N |
| French |
A |
M |
J |
U |
O |
| Italian |
A |
M |
G |
U |
O |
| Portuguese and Spanish |
A |
M |
D |
O |
N |
| Danish and Norwegian |
Y |
M |
D |
T |
N |
| Danish, Norwegian and Swedish |
Y |
M |
D |
T |
N |
| Finnish |
V |
K |
P |
T |
N |
Weekend Reference for WORKDAY.INTL & NETWORKDAY.INTL Functions
| Saturday and Sunday |
1 |
| Sunday and Monday |
2 |
| Monday and Tuesday |
3 |
| Tuesday and Wednesday |
4 |
| Wednesday and Thursday |
5 |
| Thursday and Friday |
6 |
| Friday and Saturday |
7 |
| Sunday only |
11 |
| Monday only |
12 |
| Tuesday only |
13 |
| Wednesday only |
14 |
| Thursday only |
15 |
| Friday only |
16 |
| Saturday only |
17 |
Another way to enter a weekend code into a parameter is using a string of ones and zeros. 0 represents a workday and 1 represents a weekend day. The string starts on Monday. For example "0000011" would indicate the weekend is Saturday and Sunday. "0000111" would indicate a 4 day workweek with Friday, Saturday and Sunday as the weekend days.
