How to Convert Days to Years, Months, Days in Excel

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.

Convert Days to Years, Months, Days


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.

convert days to years months days1

You should see that all days have been converted to Years, Months, Days format in your worksheet.

Convert General Number to Standard Date


#1 select cells that contain 5-digits numbers

convert days to years months days2

#2 go to HOME tab, click Number Format box, and then select Short Date from the drop down menu list.

convert days to years months days3

convert days to years months days4

You would notice that all selected numbers have been converted as a standard date format.

Related Functions


  • 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)…

Comments

So empty here ... leave a comment!

Leave a Reply

Your email address will not be published. Required fields are marked *

Sidebar