How to use Excel DAY Function

    how to use excel day function

    Quick Intro

    Extract day number from a valid excel data with Day function.

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

    Syntax

    DAY(serial_number)

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

    More Information on Excel DAY Function

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

    Examples

    In the below example, I have used day function to get day number from a date. You can use this function when you have dates in your data and you only need day number.

    Extract Day Number from a date using excel day function

    And, in the below example, I have used this function to create a dynamic formula which returns current day number and it will update every time you open your worksheet or when you recalculate your worksheet.

    Get Dynamic Day Number By Using Excel Day Function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel DAY Function you can check Microsoft’s Help Section. And, if you have a unique idea to use it, I would love to hear from you.

    There is also you have MONTH | YEAR function which is highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.