Dates

Hello Alex

Thank you for your question and welcome to the forum.

You can use the DATEDIF function as part of a text string to take a number of days and display X years Y months Z days.

If the number of days is in cell A1, enter the following to make the conversion in another cell:
=DATEDIF(0,A1,"y")&" years "&DATEDIF(0,A1,"ym")& " months "&DATEDIF(0,A1,"md")&" days"

The spaces around years and months have been put in purposefully so that the result will display with spaces in these positions in the result you will get. The & symbols create the string.

Kind regards
Amanda