DAY

Posted on 22-01-2020 , by: admin , in , 0 Comments

day

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.

Full Date The Day
25-Dec-98 25  =DAY(C4)
23-Jan-20 Mon 23  =DAY(C5)
23-Jan-20 23  =DAY(C6)
 

Example:

The =DAY function has been used to calculate the name of the day for your birthday.
Table 1:
Please enter your date of birth in the format dd/mm/yy : 3/25/1962
You were born on  : Wednesday 25  =DAY(F21)

Leave a comment