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 =EOMONTH(start_date,months) Returns the serial number of the [...]
March 2012
If you need to calculate due dates for projects or payments then Excel’s EDATE function will make life easy for you. Excel’s EDATE function is great for: calculating when a payment is due or project is to be completed calculating the date x number of months ago or into the future Excel EDATE Function Syntax [...]
A few weeks ago Karine asked me if there was a way she could find the minimum value for a specific product from a large table of data. For example, if we take this table of data, let’s say we wanted to find the lowest price for Apples. [...]
James wrote to me and asked: if he buys shares worth $2000 and gets 4% return, how many times does he need to reinvest all of his capital before he makes $1m. Of course James was quick to point out that this scenario doesn’t take into account loosing on any of his trades. Reasonable I [...]
Formulas containing dates and time in Excel can be frustrating if you don’t understand how they work. And even if you do they seem to work differently from one formula to another! A few weeks ago Dave wrote to me as he was having trouble getting a SUMIFS formula to correctly use dates referenced in [...]
... I would highly recommend My Online Training Hub for all your Microsoft Office needs .... Geniuses
