Oct 7, 2010 #1 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
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
Oct 7, 2010 #2 briangriffin Programmer Nov 6, 2008 878 US totext(floor(2176/365.25),"#",0) + " Years, " + totext(floor((2176 mod 365.25)/30),"#",0) + " Months." Upvote 0 Downvote
totext(floor(2176/365.25),"#",0) + " Years, " + totext(floor((2176 mod 365.25)/30),"#",0) + " Months."