Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Convert # of days to years/days
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!! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
CONVERT Function Disappered in Excel | Excel Discussion (Misc queries) | |||
How to convert hours in days? | Excel Worksheet Functions | |||
Subracting Dates to come up with the # of days between them | Excel Worksheet Functions | |||
Convert Numeric into Text | Excel Worksheet Functions | |||
Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions |