Excel Function Translator Logo
    The Excel Translator

    EOMONTH

    Date & Time

    Returns the last day of the month, a specified number of months before or after a date.

    Translations
    EnglishEOMONTH
    FrenchFIN.MOIS
    SpanishFIN.MES
    GermanMONATSENDE
    ItalianFINE.MESE
    PortugueseFIMMÊS
    DutchLAATSTE.DAG
    PolishDATA.KONIEC.MIESIĄCA
    RussianКОНМЕСЯЦА
    TurkishAYSONU
    CzechEOMONTH
    HungarianHÓNAP.UTOLSÓ.NAP
    SwedishSLUTMÅNAD
    DanishSLUT.MÅNED
    FinnishKUUKAUSI.LOPPU
    Syntax
    EOMONTH(start_date, months)

    Arguments

    • start_dateThe starting date
    • monthsMonths to add (negative to go back)
    Examples
    =EOMONTH(TODAY(),0)
    End of this month

    Last day of current month

    =EOMONTH(A1,1)
    End of next month

    Last day of month after A1

    =EOMONTH(A1,-1)+1
    Start of month

    First day of month in A1

    Tips & Best Practices
    • •Use months=0 for end of same month
    • •Great for calculating payment due dates
    • •Add 1 to get first day of next month
    Common Mistakes
    • •Forgetting EOMONTH returns the last day of the month as a raw date serial number, which needs date formatting applied to actually look like a date
    • •Miscounting the months argument - 0 means the current month's end, 1 means next month's end, -1 means last month's end, and it's easy to be off by one
    • •Using EOMONTH when the goal was actually the first day of the month, which needs a different, simple formula rather than EOMONTH itself
    Related Functions
    EDATEShifts a date by a number of months while keeping the same day of the month, rather than jumping to month-end.
    DAYOften combined with EOMONTH to find how many days are in a given month.
    DATECan build the first day of a month directly, a common companion calculation to EOMONTH.
    Frequently Asked Questions

    How do I get the first day of the month instead of the last?

    Use DATE(YEAR(A1),MONTH(A1),1), or EOMONTH(A1,-1)+1 to get the day right after last month's end.

    Why does EOMONTH show a number instead of a date?

    The cell needs date formatting applied - EOMONTH returns the correct date serial number, but the cell format determines how it displays.

    How do I find the last day of next month?

    Use EOMONTH(A1,1) - the months argument of 1 moves forward one month before finding its end.

    Need to translate a formula using EOMONTH?

    Use our translator to convert your complete formula