Excel DATE, SUMIFS & EOMONTH advance functions

We will see Excel's Date, SUMIFS, EOMONTH functions combined with V & X Lookup functions. Using SUMIFS formula we will sum values between two dates. Here you'll need to use the greater than & less than operators inside the SUMIFS formula. You'll also learn how to sum values within a month. For example, your data set contains dates and you'd like to create a monthly report where you show the total value for the month, you can use the SUMIFS function together with the EOMONTH (end of the month Excel formula) Lastly, you'll learn how to add more criterias to EOMONTH using in combination with X & V Lookup functions to extract the last day's data for each month. This can be highly effective if you have to analyze large data sets and want to extract the last days records of each month as required by accountants to get closing balances of debtor, creditor, inventory or bank balances. Best of Luck in your learning journey!

Timeline:-
0:00 - Intro
1:12 - Date Functions
4:40 - SUMIFS & EOMONTH (Summing data on monthly basis)
8:00 - EOMONTH & V/X LOOKUP (fetching closing month balances)
14:21 - Wrap up

[javeriakhawaja]

Very descriptive and easy to understand