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:

MS excel training module (fundamentals)


MS excel training module (fundamentals)

excel2007ppt



Hi all,

I got an opportunity in my company to provide a training to associates,  about MS Excel basics. so i prepared a MS excel training module (fundamentals).  A ppt file ( MS Excel Training(Basic) ) and a .xlsx support file for ppt ( MS Excel Training(Basic) )

I would like to share with you, so you can get some knowledge, never forget that your suggestions are very important for me.

You can download files  for following links

MS excel training module (fundamentals) PowerPoint presentation.

MS excel training module (fundamentals) MS excel support file.
ms excel 2007 training file


Share:

Popular Posts