Get serial date

Select the date cells, and right click to display context menu, select Format Cells. Click OK. Now the date in formula will be displayed as serial number. This utility can help you convert serial numbers to year, month, day, or mm-dd-yyyy or other formats.

In the Apply Date Formatting dialog, select the date format you want to apply in left pane, then you can preview the result in right pane.

Here I have a kind add-in—Kutools for Excel introduce to you, its Convert to Date utility can do you a favor. Now the dates have been converted to standard date format. Note: The other languages of the website are Google-translated. The Format Cells dialog box is very versatile and lets you perform different kinds of formatting from one place.

You can use Format Cells to convert the serial numbers in our sample dataset into dates as follows:. Note that these cells do not have the little green triangles at the top left corners. This is because these cells are of type date , and not text. So, you can perform any kind of date operations on them. In this tutorial, we saw three simple ways in which you can convert date serial numbers to actual dates in Excel.

Using the TEXT function usually results in cells that are of the text format so it requires subsequent conversion of these cells to the date format. Using Format Cells , however, you can apply the operation directly on the original cells and the results you get are of the date type. Step 4: Now for the second variable let us provide date in irregular fashion using the dateserial function as shown below.

You can also go through our other suggested articles —. Submit Next Question. By signing up, you agree to our Terms of Use and Privacy Policy. Forgot Password? This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy. Popular Course in this category. Course Price View Course.

Download Microsoft Edge More info. Contents Exit focus mode. Is this page helpful? Please rate your experience Yes No. Any additional feedback? Note For year , month , and day , if the Calendar property setting is Gregorian, the supplied value is assumed to be Gregorian. In this article. Required; Integer. Number between and , inclusive, or a numeric expression.