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

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.

When you want to know the number of days between two dates whether the date is in the future or the past, you can use Excel to calculate it.

Excel 2013 provides the DATE and XIRR functions, which derive the final annual interest rate from a series of payments on known dates.

Learn how to calculate the Simple Interest in Excel either for a single entry or a range or entries, between two dates, using this forumula.

With Excel and data from your broker, however, calculating the average return is fairly easy using the XIRR function. How to calculate average stock returns in Excel ...

Adding a running total to a simple Microsoft Excel revenue sheet isn't difficult, but adding a conditional running total will require a bit more effort. Solutions are simpler than you might think.

To calculate statistical variance in Microsoft Excel, use the built-in Excel function VAR.