How to convert a number to years, months, days?

[Biz]

I am sure this is pretty simple, but I can't seem to figure it out. I have
this number that I want to convert in years, months, days format. What
formula to use to get the munber 505 converted to that. It is not the
difference between two dates, so I can't use datedif.
thanks.

 

[Tyro]

Format the number as a date. Dates are numbers is Excel. Jan 1, 1900 is day
1, Feb 10, 2008 is day 39,488, Dec 31, 9999 is day 2,958,465. So, 505
formatted as a date is 5/19/1901 - May 19, 1901.

Tyro

 

[Niek Otten]

So, what date is the number 505 supposed to mean? In other words, what is your date system?

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


|I am sure this is pretty simple, but I can't seem to figure it out. I have
| this number that I want to convert in years, months, days format. What
| formula to use to get the munber 505 converted to that. It is not the
| difference between two dates, so I can't use datedif.
| thanks.

 

[T. Valko]

What result do you expect?

A year can have 365 or 366 days.

A month can have from 28 to 31 days.