Скачать с ютуб EOMONTH function: Finding the last day of the month in excel в хорошем качестве

EOMONTH function: Finding the last day of the month in excel

In this beginners tutorial we learn how to use the EOMONTH function in Microsoft Excel and how you use it to find the last day of a month. You can also use the EOMONTH function to find the beginning of the month (first day). Learn all the fundamentals of the EOMONTH function and how to use EOMONTN in formulas as you watch in our easy tutorial for beginners. The video shows several EOMONTH excel examples to help you get started, as well as how to use EOMONTH with the TODAY function! 0:00 Introduction 0:23 Basics of EOMONTH 0:42 Example 1: last day of this month 1:10 Example 2: last day of next month 1:23 Example 3: last day of last month 1:37 Example 4: last day of this month, next year 1:54 Example 5: last day of this month, last year 2:18 Using EOMONTH with TODAY function 2:41 Example 6: first day of this month In later videos we will look at other examples, such as how to use EOMONTH with things like the WORKDAY function to find the last or first working days of the month. Let me know in a comment if there is anything specific you'd like to see! Learn Excel online for free: Our Excel for beginners tutorial will teach you all you need to know to take you from zero to Excel hero! What Microsoft Excel tips and tricks do you want to learn? Let me know for future videos! I'll continue to develop tutorials covering Excel basics for beginners and will build up a catalogue of free Microsoft Excel course materials! :-) Check out our playlists, such as our 'Introduction tutorials for beginners' playlist:    • Excel for beginners - learn Excel wit...   Or check our other videos, such as our video on how to split values over days in a month:    • Excel for beginners: How to automatic...   Or learn the basic TIME functions, including NOW, HOUR, MINUTE, SECOND and TIME:    • Excel for beginners: Learn the basic ...