How to Calculate Years, Months, Days elapsed from a certain date in AppSheet

in AppSheet!not working dated if formula.

Calculate the number of days, months, or years between two dates using Excel functions
DATED IF

EXPAMPLE in EXCEL :
=DATEDIF(JOIN DATE, EXPIRY SERVICE, “Y”)& " YEARS " ( same as month and Days)

RESULT : “0” YEARS “0” MONTHS “0” DAYS

For example, you can calculate age in years, months, and days. You can also calculate the number of days between another date and today.

in AppSheet! able to replicate this expression?
How to Calculate Years, Months, Days elapsed from a certain date in AppSheet?

0 2 1,740
2 REPLIES 2
Top Labels in this Space