Formulas and Functions

Examples
=DAY(”4/6/88 11:59:22 PM”) returns 6.
=DAY(“5/12/2009”) returns 12.
Related Topics
For related functions and additional information, see:
“DAYNAME” on page 48
“HOUR” on page 51
“MINUTE” on page 52
“MONTH” on page 53
“SECOND” on page 56
“YEAR” on page 62
“Listing of Date and Time Functions” on page 42
“Value Types” on page 36
“The Elements of Formulas” on page 15
“Using the Keyboard and Mouse to Create and Edit Formulas” on page 26
“Pasting from Examples in Help” on page 41
DAYNAME
The DAYNAME function returns the name of the day of the week from a date/time
value or a number. Day 1 is Sunday.
DAYNAME(day-num)
 day-num: The desired day of the week. day-num is a date/time value, or number
value in the range 1 to 7. If day-num has a decimal portion, it is ignored.
Examples
If B1 contains the date/time value August 2, 1979 06:30:00, C1 contains the string 10/16/2008, and D1
contains 6:
=DAYNAME(B1) returns Thursday.
=DAYNAME(C1) returns Thursday.
=DAYNAME(D1) returns Friday.
=DAYNAME(“12/29/1974”) returns Sunday.
48 Chapter 3 Date and Time Functions