Converting number of days

  • Thread starter Thread starter Radrays
  • Start date Start date
R

Radrays

How can I convert a number into days, months and possibly years?

I have the number 195.4642 which equals a number in days. I need that
number represented as months and days.

I am currently using XP - Office 2007

Thank you,
Radrays
 
So how many days do you think are in a month? Doesn't it depend on the date
from which you start counting?

Try =DATEDIF(B1,A1+B1,"y")&" years, "&DATEDIF(B1,A1+B1,"ym")&" months,
"&DATEDIF(B1,A1+B1,"md")&" days"
with your number of days in A1 and the starting date in B1.
 
Back
Top