If you have to work with a date stamp in Microsoft Excel that includes date and time, you can use these simple expressions to extract both components, making them easier to work with.

Creating a list of duplicate values that’s separate from the data source is easier than ever thanks to Microsoft Excel's FILTER() function.

The lookup function in Excel can save you a lot of time and effort, but only if you actually know how to use its many forms and alterations.

Obtain a list of all dates between two given dates in Excel using formula The formula to obtain a list of all dates between two given dates in Excel is a little complicated.