Continuing on from last week’s EDATE function, today we’re looking at the EOMONTH function.
If you use Excel to generate invoices and your payments are due at the end of the month you can use the EOMONTH function to automatically enter the payment due date.
Excel EOMONTH Function
Returns the serial number of the last day of the month before or after a specified number of months.
Extra Tip – Calculate End of Month Date from Today
Use this on invoice templates where invoices are due at the end of the month.
Or if your credit terms are EOM+30 days then use:
Note: if the date displays as a serial number simply change the formatting to a Date format. CTRL+1 to open formatting dialog box.
More on working with time and dates in Excel