Hi!

The reason you're getting 1 year 28 days is because 425 is the date serial
number for Feb 28 1901.

This may be a little overkill but it does what you want and assumes that ALL
years are 365 days:

=INT(A1/365)&IF(INT(A1/365)=1,"Year ","Years
")&IF(MOD(A1,365)=1,MOD(A1,365)&" Day",MOD(A1,365)&" Days")

Biff

"Marlene Mayer" wrote in message
...
I'm having a bit of a problem with a format that I think should work, but
isn't. I'm trying to convert the total # of days to years/days. For
example, in Column A1, I have 425 as the # of days. I've formatted Column
B with a custom format of yy "Years" dd "Days". For 425 days, it should
end up giving me a result of approximately 1 Year 60 Days, however it is
returning a result of 1 year 28 days. Any assistance that can be offered
with this would be greatly appreciated, thanks!!