In this post, we will show you how to calculate the expiry date in Microsoft Excel. Calculating expiry dates is a common requirement when working with Excel, especially for tracking inventory, ...

One of the most popular tasks in Microsoft Excel is filtering dates by month, or another particular criterion. However, there are times when the Excel date filter grouping does not work as intended, ...

The EOMONTH function in Microsoft Excel returns the last day of a month in the past, the current month, or a month in the future. Whether you need to calculate end-of-month due dates, deadlines, ...

How to Use TODAY() to Highlight Fast-Approaching Dates in an Excel Sheet Your email has been sent Use Microsoft Excel's TODAY() function in simple expressions to highlight the current date and past ...

Have you ever grouped data in Excel only to find your months sorted alphabetically instead of chronologically? It’s a frustrating quirk of the GROUPBY function, one that can turn a clean dataset into ...

How to create a YOY comparison chart using a PivotChart in Excel Your email has been sent Need to know your organization's YOY results? Susan Harkins will show you how to make a PivotChart in ...