Formula

H

Heraud

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

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?
 
Top