EOMONTH Function in Excel: How to + 8 Examples | Excel Off The Grid

★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy

★ Get the example file ★
https://exceloffthegrid.com/quarter-f...

★ About this video ★
One of Excel's most useful functions for accountants, financial modellers and data analysts is the EOMONTH function. This function calculates the last day of a month, based on a specified number of months in the past or future.

From the name, EOMONTH, it may not be clear what the function does. Once we realize EOMONTH stands for "End Of MONTH", suddenly its purpose becomes much clearer.

There are a few quirks with this function, so in this video, we look at the EOMONTH function in Excel and work through 8 examples.

0:00 Introduction
0:32 Syntax and basic usage
2:30 Example: End of current month
3:05 Example: Start of month
4:16 Example: Dates as text
5:59 Example: Using the DATE function
6:40 Example: Financial month
8:00 Example: EOMONTHS with SUMIFS
9:40 Example: Spilling with SEQUENCE
11:13 Example: Spilling the start_date
12:03 Conclusion

★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/

★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter:   / exceloffthegrid  

#MsExcel