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.

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 ...

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.

We show you how to use Excel to count days between two dates using the DAYS, DATEDIF, NETWORKDAYS, and TODAY functions, and Subtraction.

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

How to Calculate Average on Excel From Multiple Sheets. Microsoft Excel 2010 provides a formula for calculating the average value from multiple worksheets in a workbook.