Convert Numbers (Days) to To Year/Month

Karrie DavisKarrie Davis Overachievers
edited 12/09/19 in Formulas and Functions
01/19/19 Edited 12/09/19

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

Sign In or Register to comment.