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.

Importing data into Excel from other sources can result in long, messy strings of text you need to parse. We'll show you how.

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

Excel is a powerful software that can do more advanced tasks than you may imagine. You can get Excel to automatically update the date in your Excel document each time you open it. Learning how to ...

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.

Excel may return a serial number instead of a date; because it is stored thus in the backend. Learn how to convert Serial Number to Date.

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.

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.