Direct Answer • Key Takeaway
Months – the Number of Months Before or After the Start Date. Use a Positive Value for Future Dates and Negative Value for Past Dates. Here Are a Few Eomonth Formula Examples: =Eomonth (A2, 1) – Returns the Last Day of the Month, One Month After the Date in Cell A2.