Day Formula
|
|
Full Date
|
The Day
|
|
|
|
|
|
25-Dec-98
|
25
|
=DAY(C4)
|
|
|
|
|
25-Sep-11
|
Wed 25
|
=DAY(C5)
|
|
|
|
|
25-Sep-11
|
25
|
=DAY(C6)
|
|
|
|
|
|
|
|
|
|
|
What Does It Do?
|
|
|
|
|
|
|
This
function extracts the day of the month from a complete date.
|
|
||||
|
|
|
|
|
|
|
|
Syntax
|
|
|
|
|
|
|
=DAY(value)
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Formatting
|
|
|
|
|
|
|
Normally the
result will be a number, but this can be formatted to show the actual
|
|||||
|
day of
the week by using Format,Cells,Number,Custom and using the code ddd or dddd.
|
|||||
|
|
|
|
|
|
|
|
Example
|
|
|
|
|
|
|
The =DAY function
has been used to calculate the name of the day for your birthday.
|
|||||
|
|
|
|
|
|
|
|
|
|
|
Please enter your date of birth in
the format dd/mm/yy :
|
3/25/1962
|
|
|
|
|
|
You were born on :
|
Wednesday 25
|
=DAY(F21)
|