Convert Numbers (Days) to To Year/Month

Karrie Davis
Karrie Davis Overachievers Alumni
edited 12/09/19 in Formulas and Functions

I'm trying to convert number of days to year and month. In excel I would use the following formula

=DATEDIF(0,[Days closed]11,"y") &" years, "&DATEDIF(0,[Days closed]11,"ym") &" months"

 

Though this formula does not work in smartsheet is there another way to do this

 

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!