DAY ()
This function extracts the day of the month from a complete
date.
Best view in desktop mode.
|
A
|
B
|
C
|
|
|
1
|
Full Date
|
The Day
|
|
|
2
|
25-Dec-19
|
25
|
=DAY(A2)
|
|
3
|
21-Feb-20
|
Sat 21
|
=DAY(A3)
|
|
4
|
21-Feb-20
|
21
|
=DAY(A4)
|
|
5
|
Syntax
=DAY()
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.
Shortcut Key for Formatting
Go to B3 cell,
Press Ctrl+1, and you will see new pop-up window like below:
Example
The =DAY function has been used to calculate the name of the
day for your birthday.
|
A
|
B
|
C
|
|
|
1
|
Please
enter your date of birth in the format dd/mm/yy :
|
3/25/2002
|
|
|
2
|
You
were born on :
|
Wednesday 25
|
=DAY(B1)
|
|
3
|
No comments:
Post a Comment