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?

2 Likes

How to Calculate Days?
whats the duration of service?
EXAMPLE:
Join Date 1-Jan-2019 Expiry Today 25-Sep-2020

**Result should be **
1 year 8 months 25 days
how can?