Excel already knows when the month ends.
Excel isn't hard, just learn the right tricks early enough.