How to Convert Dates to Years in Excel. When you use Microsoft Excel to store and analyze business data, your workbooks and worksheets often contain date information. Although your original data ...

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

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

If numbers keep changing to dates automatically in Excel or if Excel changes dates to random numbers then this post will help you fix the issue.

Excel VBA functions to calculate the time in other time zones These functions use the Microsoft Outlook 16.0 Object library to convert the date and time in a reference time zone to another destimation ...

An Excel autocorrect feature that has driven geneticists crazy for years has finally been rectified. Even if you're not a scientist studying genentics, you've surely come across this issue. When ...