How to Convert Numbers (Days) To Year/Month/Day - OneSite

Breaking

EVERYTHING IS HERE

Post Top Ad

Post Top Ad

Wednesday, March 20, 2019

How to Convert Numbers (Days) To Year/Month/Day

 

Convert Numbers (Days) To Year/Month/Day

This method will introduce a formula to convert the number of days to year/month/day such as "1 year 4 months 25days" in Excel. Please do as follows:
Select a blank cell you will output the conversion result, and enter the formula =DATEDIF(0,A2,"y")&" years " &DATEDIF(0,A2,"ym")&" months "&DATEDIF(0,A2,"md")&" days"  (A2 is the cell with number of days that you will convert to year/month/day) into it, and press the Enter key.
doc convert number to date year month day 1

Keep selecting the cell of conversion result, and drag its Fill Handle to the range as you need. And then you will see all numbers are converted to year/month/day. See screenshot:
doc convert number to date year month day 2
ad to actual 2

No comments:

Post a Comment

Post Top Ad