Browsed by
Category: Date & Time Functions

Return the first or last day of the month with EOMONTH

Return the first or last day of the month with EOMONTH

There are many instances where Excel users may want to return the first or last day of the month from a cell referencing a date. This can include creating additional mapping so that formulas work using one date as a criteria rather than a ranges of dates, and being able to summarise data in a more simple way.