Sorts are a simple task in Microsoft Excel if all you need is an ascending or descending sort. Excel is smart enough that it can interpret the data range. Not all sorts are so easy. Fortunately, Excel ...

How to group time values by the hour in Excel Your email has been sent Grouping records by dates or time is easy in Microsoft Excel, but it doesn’t make a great report. For instance, a simple sort by ...

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

Finding the exact difference between two dates in Excel may not be the most used feature, but it can be a lot of fun. A classic example is working out someone’s age. It’s not as complicated as it ...

Recently I came across a Power Apps solution that needed to sort a collection by a date column. In this post the pains of sorting by date fields and how to work around them. Now there are a few ...