Description
Used to return a serial number of the day within the month for the given date. The DAY function can be useful in various nested functions and can provide input for functions while excel modeling.
Remember never to confuse DAY with the DAYS function, in which excel returns the number of days between two dates.
=DAY(serial_number)
The DAY function syntax has the following argument:
- Serial_Number Required.
The date of the day you are trying to find.
Note: Avoid directly punching dates into Excel function, instead of either use DATE function or put date within inverted commas (“”) in this sequence i.e. Month/date/year. Otherwise excel will read the date as ZERO.
