Apr 30 2020 12:25 AM
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 years there are. However, this doesnt work on excel when I tried it. There was an error message that suggested there were too many arguments in the equation.
Does anyone know of any alternatives instead?
Thanks so much in advance!
Apr 30 2020 12:32 AM
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.
Apr 30 2020 12:33 AM
@vicneoh The syntax for this would be:
=DATEDIF(<start date>, <end date>,"option")
where "option" is Y, M or D.
Apr 30 2020 12:39 AM
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.
Apr 30 2020 12:47 AM
Thanks for this! I realise the issue is with my mac. Tried it on windows and it works..hmm.
Apr 30 2020 12:50 AM
Apr 30 2020 05:44 AM
Apr 30 2020 06:00 AM
Initial question was like
We spent 456 days, how many full months is it?
Perhaps TEXT() is not very suitable here.