Assuming you have 76 in A1, then
For Years
For Months![]()
=INT(A1/52.177457)
For Years & Months![]()
=INT(A1/4.34812)
![]()
=INT(A1/52.177457)&" Year "&INT(MOD(A1,52.177457)/4.34812)&" Months"
Assuming you have 76 in A1, then
For Years
For Months![]()
=INT(A1/52.177457)
For Years & Months![]()
=INT(A1/4.34812)
![]()
=INT(A1/52.177457)&" Year "&INT(MOD(A1,52.177457)/4.34812)&" Months"
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks