Learn how to highlight dates before today and a specific date with and without using the Today() function in Microsoft Excel.

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

Key Takeaways The Microsoft Excel Advanced Formula Environment (AFE) is a tool designed to enhance the user experience when working with complex formulas in Excel.

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

Excel provides one general formula that finds the difference between numbers, dates and times. It also provides some advanced options to apply custom formats to your results.