DAY Function (Functions in Excel)
Full Date | The Day | |
25-Dec-98 | 25 | =DAY(C4) |
11-May-10 | Wed 11 | =DAY(C5) |
11-May-10 | 11 | =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) |
0 comments:
Post a Comment