From the course: Excel: Advanced Formulas and Functions

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

EOMONTH

EOMONTH

From the course: Excel: Advanced Formulas and Functions

Start my 1-month free trial Buy for my team

EOMONTH

“

- [Instructor] EOMONTH can be really handy if you work with a lot of dates and you have to set deadlines. EOMONTH is "end of month." So we have people who purchased materials and then we say, "You've got until the end of the month to get your work done." So let's use EOMONTH. Double-click. The start date, comma, months. If we want the same month, we need to put in a zero here. Close the parentheses and enter, and then send this down. But we have to deal with the formatting. I'm going to highlight here and then go home. The paint brush and then there we go. For the person who purchased on the 12th of March, they have until the 31st of March. We don't have to calculate it, right? I'll figure out whether it's got 30 days, 31 days. Let's add another month in here. 15 November, 23. All right and then how about two, February 23, automatic. Right now, here's a situation where people get three months, equals EOMONTH.…

Contents