calculate the number of years, months and days between two dates in zoho spread sheet? .

calculate the number of years, months and days between two dates in zoho spread sheet? .

Hi senior,

How we calculate the number of years, months and days between two dates in zoho spread sheet? .



= 'YEARS(A1,B1, "Y")&"YEARS, "&MONTHS(A1,B1," ym")&"MONTHS, "&DAYS(A1,B1,"md")&"DAYS

    Is this  the right answer.