how i can convert days to year in google doc spreadsheet
A:
You can't make an exact conversion from days to years, as a year is not an exact unit, i.e. the length of a year varies depending on which year it is.
You can get an approximate value by dividing by 365. You can get a better approximate value by dividing by 365.24.
Guffa
2010-09-11 10:19:43
Or... `365.2425` ;P
Delan Azabani
2010-09-11 10:23:06