EMONTH Function

Microsoft training delivered by certified trainers, and a microsoft partner training company
excel training Excel EOMONTH Function Explained

When using Excel to produce invoices, and payments are due at the end of the month, use the EOMONTH function to automatically insert 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.

Excel EOMONTH Function

How to – 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: =EOMONTH(NOW(),1)

Note: if the date displays as a serial number simply change the formatting to a Date format. CTRL+1 to open formatting dialog box

Excel can be fun try out some of its features Detailed on this Site


Mike Barrett (MCT) Senior Training Advisor