hi Luke M

10s! it works fine.

grateful to your guidance
&
thanks! community as well
--
oldLearner57


"Luke M" wrote:

Assuming you're measuring from today's date as a baseline, and the value of
790 is located in cell A2, formula is:

=DATEDIF(TODAY(),TODAY()+A2,"y")&" years "&
DATEDIF(TODAY(),TODAY()+A2,"ym")&" months
"&DATEDIF(TODAY(),TODAY()+A2,"md")&" days"
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"oldLearner57" wrote:

hi community

how can i convert total 790 days into years, months, days

thanks community for the guidance


--
oldLearner57