How to use DAY Function in Excel

How to use DAY Function in Excel2018-11-16T10:07:34+00:00

The DAY function extracts the day from a valid date.

In simple words, it returns day from a date ignoring month and year. The number of the day ranging from 1 to 31 from a date you have mentioned.

Syntax

DAY(serial_number)

  1. serial_number A valid serial number of date from which you want to extract day number.

Examples

In the below example, we have used DAY function to simply get day from a date.

extract day number from a date using excel day function
get dynamic day number by using excel day function

Remember

  1. Excel stores date in serial number and day function will only get day number from a date with a valid serial number.
  2. It will only return day number from a date with year ranging from 1900 to 10000.
  3. You can also insert a date directly into the function by using quotation marks.

Sample File



Content Protection by DMCA.com