Hello everybody
I have this number 5425
I need to convert this number to Years, Months and days
Is there a UDF Function that can do that task?
Hello everybody
I have this number 5425
I need to convert this number to Years, Months and days
Is there a UDF Function that can do that task?
This number represents what exactly?
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
Good afternoon YasserKhalil
Try this - bit of a fudge but it should work OK :
Cell A1 :Formula:Please Login or Register to view this content.
Cell B1 :Formula:Please Login or Register to view this content.
Cell C1 :Formula:Please Login or Register to view this content.
HTH
DominicB
Thanks a lot for this great help
just for sake of testing if i am learning anything
with your number of days in A1 try this in B1
Please Login or Register to view this content.
◄Ŧя?μвŁ?►
By Name & By Nature
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks