TheEOMONTH functionis one of those little gems in Excel that can save you a lot of trouble.
Need help with formulas?
We havemore than 500 formulas examples, andhigh-quality video trainingif you like learning with a structured program.
The EOMONTH function - Formula Friday
The EOMONTH function is one of those little gems in Excel that can save you a lot of trouble. It's a simple function that does just one thing: given a date, it returns the last day of a month. You can use EOMONTH to build all kinds of useful Excel formulas.
