How To Use Excel Month Function

    how to use excel month function

    Quick Intro

    Excel MONTH Function can extract the number of the month from a specified date ranging from 1 to 12.

    What Is Excel MONTH Function

    In above example, I have used month formula to get the month number from the given date. As January is the first month of the year so, month function returns 1 as month number.



    serial_number A valid date as per the excel date serial numbers.

    More Information on Excel MONTH Function

    • Date from which you want to get the month number should be a valid date.
    • If you mention an invalid date it will return #VALUE! error.
    • if you skip entering any value in serial_number it will return 0.


    In the below example, we have used month formula along with today function to get the month. It will always give the number of current month whenever date changes.

    Excel Month Function With Today Function

    In the below example, we have used month function along with CHOOSE and TODAY. This dynamic formula will return the name of the month instead of month number.

    Excel Month Function With Today Function

    Sample File

    download sample file to learn more about this tips

    What’s Next?

    To learn more about Excel MONTH 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 are also you have DAY | YEAR functions which are highly useful. Apart from this, I have a list of excel functions and some real life formulas examples.