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

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

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 the Midpoint of Two Dates in Excel. When you enter a number into an Excel cell that looks like a date, such as "Jun-1" or "6/1," Excel automatically adjusts the format of the cell ...

Microsoft Excel provides an easy way to calculate payback periods. The formula for calculating the payback period is the initial investment divided by incoming cash flows.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Excel percentage formulas can help with many everyday applications. We'll walk through several examples, including turning fractions to percentages, and calculating percentage of total, increase ...