Calculate the Last Day of Each Month

A common question in my Excel classes is “how do I automatically calculate the last day of each month?” For many people this represents pay-day or invoice-delivery day. So here goes… Of course, you could just type the dates in yourself but apart from the...

Loan Repayment Calculator (PMT & EOMONTH)

In this tutorial I demonstrate how to create a loan calculator. I use Excel 2011 for Mac but it also works just the same in all Windows versions. I use a number of functions including: – TODAY – to calculate today’s date – EOMONTH – to...