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.

How to Calculate Hours in Excel Excluding Weekends. An Excel spreadsheet can become an indispensable tool for your business when you harness its power for keeping records and doing computations.

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.

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

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