Full
Date
|
The
Day
|
||||
25-Dec-98
|
25
|
=DAY(C4)
|
|||
2-Feb-17
|
Mon 2
|
=DAY(C5)
|
|||
2-Feb-17
|
2
|
=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)
|
|||
No comments:
Post a Comment