The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the ...

How to Calculate Past Due Date on MS Excel. Excel's EDATE and NOW functions can be used to track when an account is overdue, and let the person managing the account know when to send a reminder ...

The article How to calculate conditional subtotals in an Excel revenue sheet uses simple expressions, a function, and a conditional format to display a daily balance in a revenue sheet.

Adding a condition to a simple revenue sheet might spell trouble in Microsoft Excel, but don't worry--a simple conditional function can handle the request.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.