Display Date Format in Days, Months and Years

CodeDescriptionDisplay
dDay is displayed as a number, as one digit or as two digit.1-31
ddDay is displayed as a number, as two digit, with a leading zero where applicable.01-31
dddDay is abbreviated to three letters, viz. Sunday is displayed as Sun.Sun-Sat
ddddDay is displayed in its full format, viz. Sunday is displayed as Sunday.Sunday-Saturday
mMonth is displayed as a number, as one digit or as two digit.1-12
mmMonth is displayed as a number, as two digit, with a leading zero where applicable.01-12
mmmMonth name is abbreviated to three letters, viz. January is displayed as Jan.Jan-Dec
mmmmMonth is displayed in its full name, viz. January is displayed as January.January-December
mmmmmMonth is displayed as a single letter, viz. January is displayed as J.J-D
yyYear is displayed as a number in two digits, viz. last 2 digits of the year are displayed.00-99
yyyyYear is displayed as a number in four digits, viz. all digits of the year are displayed.1900-9999

Popular posts from this blog

50 Excel VBA Oral Interview Questions