converting days to years & months & days
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
|