The DAY function converts a serial number to a day of the month. The day is returned as an integer ranging from 1 to 31.

DAY takes 1 required argument and no optional arguments:

Syntax: DAY(serial_number)

#1)
Using the DAY function:
Note:
Excel stores dates as sequential serial numbers so they can be used in calculations. By default, January 1, 1900 is serial number 1, and January 1, 2014 is serial number 41640 because it is 41,640 days after January 1, 1900.
#2)
The arguments for the DAY function are:
Argument Required? Description
serial_number Required The date of the day you are trying to find. Dates should be entered by using the DATE function, or as results of other formulas or functions.

Summary

The DAY function converts a serial number to a day of the month.
comments powered by Disqus