### Re: How to calculate in a period: Years, Months and days.

Posted:

**Thu Jul 18, 2019 5:53 pm**If you don't want multiple cells

and

if you want years/months/days missing if 0 and singular/plural

and

if you want years/months/days missing if 0 and singular/plural

- Code: Select all Expand viewCollapse view
`=IF(YEARS(B1;B2;0)=0;"";YEARS(B1;B2;0)&IF(YEARS(B1;B2;0)>1;" years ";" year "))&IF(MOD(MONTHS(B1;B2;0);12)=0;"";MOD(MONTHS(B1;B2;0);12)&IF(MOD(MONTHS(B1;B2;0);12)>1;" months ";" month "))&IF(DAY(B1)=DAY(B2);"";B2-EDATE(B1;MONTHS(B1;B2;0))&IF(B2-EDATE(B1;MONTHS(B1;B2;0))>1;" days";" day"))`