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 ...
Microsoft Excel's TEXT function can help you to convert a date to its corresponding month name or weekday name easily. In a blank cell, please enter this formula =TEXT(A2, "mmmm"), in this case in cell C2. , and press the Enter key. And then drag this cell's AutoFill handle to the range as you need.
Initial question was like
We spent 456 days, how many full months is it?
Perhaps TEXT() is not very suitable here.
