Jul 21, 2014
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...
Mar 23, 2013
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...
