Why eomonth() function?

[lezawang]

Hi
I watched around 10 videos about Eomonth() function. I know how to use it now. I still do not understand why I need it. It is not difficult to find the end of month date. In one video, he said he would find the 5th date of the next month so he added Eomonth()+5 but again, that is not difficult to find and know. I wish I can see one real life example that it is really useful to use eomonth(). Thank you very much.

 

[Michael M]

Well, as a comparison, I'd rather use EOMONTH() than

=DATE(YEAR(TODAY()),MONTH(TODAY())+1,1)-1

OR

=DATE(YEAR(TODAY()),MONTH(TODAY())+3,1)-1

 

[Joe4]

In Excel, there are often multiple ways to do things. You can add up a series of numbers with using SUM. You can calculate your own average without the AVERAGE function.
Having the EOMONTH function just makes it easier than having to do find the first day of the following month and subtract one.

I don't know about you, but I am usually all about convenience!