LinkBack URL
About LinkBacks
Hey whats up everyone? Hope all is well here in excel land.
Alright here I go, I have a number (1.48) what can be used to display years, months and days?
thx,
mrggutz
Hey whats up everyone? Hope all is well here in excel land.
Alright here I go, I have a number (1.48) what can be used to display years, months and days?
thx,
mrggutz
Last edited by mrggutz; 03-04-2011 at 10:28 AM.
I don't quite understand what you need. Could you please provide an example?
yes here is a sample.
thx
If you want A1+1.48 years then try
=A1+B2*365.25
format as date
Audere est facere
Something like this perhaps
Providing all months have 30 days
Please Login or Register to view this content.
ya that will display a date to completion thats good too, still would like it to have it display year, month and day thou.
thx
see Arthurbr's suggestion or perhaps
=INT(B2)&" yrs "&DATEDIF(0,B2*365,"ym")&" mths "&DATEDIF(0,B2*365,"md")&" days"
Man ya are awesome thats why I come here thx guys and have a great weekend.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks