This post will guide you how to convert a given day numbers into Years, Months, Days in Excel. How do I convert days to Years, Months, Days with a formula in Excel. How to convert a general numbers to a standard date in Excel.
If you want to convert a given day numbers to Years, Months, Days in your worksheet, you can use an Excel formula based on the DATEDIF function. Like this:
=DATEDIF(0,B1,"y") & " Years " & DATEDIF(0,B1,"ym") & " Months " & DATEDIF(0,B1,"md") & " Days "
You need to type this formula into a blank cell and press Enter key on your keyboard, and then drag the AutoFill Handle over to other cells to apply this formula.
You should see that all days have been converted to Years, Months, Days format in your worksheet.
#1 select cells that contain 5-digits numbers
#2 go to HOME tab, click Number Format box, and then select Short Date from the drop down menu list.
You would notice that all selected numbers have been converted as a standard date format.
- Excel DATEDIF function
The Excel DATEDIF function returns the number of days, months, or years between tow dates.The syntax of the DATEDIF function is as below:=DATEDIF (start_date,end_date,unit)…