Here are the 17 most useful accounting functions in Microsoft Excel to make financial data monitoring and reporting easier and faster.

DATEDIF (), which means Date + Dif, is a compatibility function left over from Lotus 1-2-3 that Microsoft adopted in Excel version 2000. It's fallen off current Excel menus, but you can still use it.

Using three Microsoft Excel functions, you can easily parse time components from a full date value.

Bookkeepers, project managers, HR departments and more use the Excel Date & Time functions WEEKNUM, ISOWEEKNUM, WORKDAY, WORKDAY.INTL to calculate time. Here's how.

Both EDATE and EOMONTH calculate dates in a month. In this tutorial, we are going to explain how to use EDATE and EOMONTH in Excel.

Formulas are powerful tools for performing calculations and analyzing data in Excel. In this beginner’s guide, you’ll learn how to use formulas and explore some popular built-in functions.

If you would like to improve your Excel workflows and spreadsheets and in the process save a huge amount of time you might be interested in mastering Excel date functions. Once mastered this ...

Save time and effort by learning how to use the TIME() function in Excel to enter a series of incremental times in this step-by-step guide.

Excel formulas start with an equal sign followed by the function The syntax of a function refers to its structure, including the arrangement of the function's name and its arguments. A function is ...

A volatile function is a function that recalculates every time a change is made to an Excel worksheet, or whenever an existing workbook is reopened. Going one step further, when a volatile function is ...