Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert total days into year and months

Status
Not open for further replies.

sto837

Technical User
Aug 11, 2009
20
US
Hi,

Is there a formula where I can convert total days into year and months? For example, the total days are 2176, and it is approx 5 years and 10 months.

Thanks
 

totext(floor(2176/365.25),"#",0) + " Years, " +

totext(floor((2176 mod 365.25)/30),"#",0) + " Months."

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top