Last day of a month, EOMONTH function

Some­times, we need to know what the last day of the moth is. In fact, it’s real­ly sim­ple to find it out because we have the end of month func­tion — EOMONTH. This func­tion needs a start­ing day and the num­ber of moths we are mov­ing. When we want the end of the cur­rent month, we just put 0 in the sec­ond argu­ment of the func­tion. Then, we must close the for­mu­la and that’s it (Fig. 1).

=EOMONTH(A2,0)

We have the last days of cur­rent months. The EOMONTH func­tion shows the last day even if the start­ing day is the last day of the month (Fig. 2).

The EOMONTH func­tion can move to the future. When we want to go one month into the future, we just put pos­i­tive num­ber (for exam­ple 1) instead of 0 (Fig.3).

=OEMONTH(A2,1)

And we have the last days of the next month (Fig. 4).

If we put a big­ger num­ber (Fig.5),

=EOMONTH(A2,3)

we will move more into the future (Fig. 6). 

Ana­log­i­cal­ly, if we want to move back in time, we just write a neg­a­tive num­ber. Let’s write ‑1 (Fig. 7). 

=EOMONTH(A2, ‑1)

And we are in the pre­vi­ous month (Fig. 8).

If we want to move even more into the past, we just write big­ger neg­a­tive num­bers (Fig. 9).

=EOMONTH(A2,-3)

As a result, the EOMONTH func­tion can move us even to pre­vi­ous or next years (Fig. 11).