Use Of Day
Full Date
|
The Day
| ||||
25-Dec-98
|
25
|
=DAY(C4)
| |||
30-Mar-17
|
Mon 30
|
=DAY(C5)
| |||
30-Mar-17
|
30
|
=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 :
|
25-03-1962
| ||||
You were born on :
|
Wednesday 25
|
=DAY(F21)
| |||
कोई टिप्पणी नहीं:
एक टिप्पणी भेजें