end of month eomonth

EOMONTH

The EOMONTH formula, or End of Month, yields as a serial number and can be used to calculate the last day of a given month. This formula is often used by accountants and financial management to calculate maturity dates or due dates. EOMONTH can be used for a variety of functions.