Using three Microsoft Excel functions, you can easily parse time components from a full date value.

How to parse dates using TEXTSPLIT () in Excel Another common parsing task is dates. We generally enter dates as an entire date but also need the components.

How to Convert 5-Digit Julian Dates to Regular Dates in Excel. The Julian date format is a five digit number broken into two parts: a two-digit representation of the year followed by a three-digit ...

It's easy to change the date format in Microsoft Excel. You just need to use the "Date" drop-down menu, which gives you plenty of options.

2] Dates are in the future Here you will see how to subtract from today if the date or dates you want to use are in the future. In this article, additional information will be added to Excel to ...

Excel filters help you find exactly what you want, no matter how big your spreadsheet database is. Here's how to set number, text and data filters.

Excel offers several easy ways to calculate expiry dates. This post explores different ways to automate expiry date calculations in Excel.

One of the many features of Excel is being nosy. That's right, you can quickly calculate a persons age as long as you have their birth date.