DAY Function Dictionary
Function Dictionary | Function Examples | Function Categories |
DAY | ||||||||
Full Date | The Day | |||||||
25-Dec-98 | 25 | =DAY(C4) | ||||||
7-Feb-16 | Sat 7 | =DAY(C5) | ||||||
7-Feb-16 | 7 | =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) | ||||||