Best Online Learning Platform and Collect Information

How Do I convert days counts in to #Year, #Months, #Days

On the my colleague walked up to me and asked

Vikash, How Do I convert days counts in to #Year, #Months, #Days.    

Like 689 to 1 Year, 10 Months, 24 Days.

So i did some exercise and share a formula with him for the same and sharing with public also. I hope it will helpful for others.
                                                                                                                                                Suppose that your days count is in to the cell A2
convert days counts in to year, months, days

Then formula will be:-
=INT(A2/365)&" Years, "&INT((A2-(INT(A2/365)*365))/30)&" Months, "&A2-(INT(A2/365)*365)-(INT((A2-(INT(A2/365)*365))/30)*30)&" Days"

Replace A2 with the required same. 

Note: - A little error in with this formula, it will count only 30 days per month not 31 days.
Share:

Popular Posts