In many cases, you need to calculate the last date of a month based on a given date. If I give you an example then it would be very clear. Assume that, you got a joining date and question is how many days you have worked on that joining month? To find the last date you can take help from EOMONTH() function. But in this article I will show you how you can do that in 3 ways. Before going to start design your worksheet like below image: Image 1: Before calculate the last day of the month 1. EOMONTH(): In EOMONTH() function "EO" means "End of". This function needs to supporting values to calculate the last date of the month. First is the "start date", means a date based on you need to calculate the last date of that month. And second is, which month? Here you should remember: 0 = Current month based on given date 1 = Next Month -1 = Previous Month. You can use Next 11 months and previous months by using 11 or -11. Ok, enough describing. Now ...
Learn Microsoft Excel with step by step tutorials including charts, formulas, functions, Power BI, Excel VBA for beginners.