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
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.
0 comments:
Post a Comment