Forum Discussion
Converting days to Year and Month
Hello, I've been trying to convert number of days into years and months. I've looked up some formula which tells me that I can use =DATEDIF(0,(cell with no. of days),"Y") to generate the number of ...
In general it works, e.g.
=DATEDIF(0,365,"Y") returns 0 and =DATEDIF(0,367,"Y") returns 1
If not full years, when like
=YEARFRAC(1,365) returns 0.9972
But above is for Windows, not sure about Mac with it's shifted dates scale.
Didn't even realise you could use DATEDIF that way. Hence, my response using start and end dates. Tried yours and can conform its the same on a Mac.