G Guest Nov 24, 2003 #1 I need to convert a number into year/month/day. For example, the number 384 is equal to: 1 year, 19 days. Is there a formula that can calculate this?
I need to convert a number into year/month/day. For example, the number 384 is equal to: 1 year, 19 days. Is there a formula that can calculate this?
J J.E. McGimpsey Nov 24, 2003 #2 For year and day this is easy (assuming, from your example, that all years have 365 days): A1: 384 A2: =INT(A1/365) & " year, " & MOD(A1,365) & " days) However, you also ask for y/m/d - how long is a month? 28 days? 31 days?
For year and day this is easy (assuming, from your example, that all years have 365 days): A1: 384 A2: =INT(A1/365) & " year, " & MOD(A1,365) & " days) However, you also ask for y/m/d - how long is a month? 28 days? 31 days?
