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.
Thanks for this! I realise the issue is with my mac. Tried it on windows and it works..hmm.