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

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

To extract and sort non-adjacent arrays in your data, nest the CHOOSECOLS or CHOOSEROWS functions inside your SORT or SORTBY ...

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

Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past and future dates.

How can I add or subtract months from a date using the EDATE function in Excel? To use the EDATE function you will need the starting date and the number of months to add or subtract.

Boolean logic: The method used to evaluate conditions, returning either TRUE or FALSE. Logical functions: The primary logical ...

Learn how to calculate the net present value (NPV) of your investment projects using Excel's XNPV function.

Microsoft Excel’s new text function TEXTSPLIT() is Excel’s TEXT TO COLUMNS feature in a formula and a bit more.