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

AppSheet AppSheet Q&A
,
1

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

Convert Birthdate to Current Age in Years/Months format Tips & Tricks ?

Calculating the current Age based on a date-of-birth column: [48%20AM] Formula FLOOR(HOUR(TODAY()-[DOB])/365/24)&" yr “& FLOOR(MOD((HOUR(TODAY()-[DOB])/24),365)*12/365) & " mo” Line 1 HOUR(TODAY()-[DOB]) returns the number of Hours in the duration /365/24 converts hours to years, and FLOOR gives the number of full years, dropping the decimal. Line 2 (HOUR(TODAY()-[DOB])/24) returns the number of days in the duration MOD((…),365) finds the remainder in days, after removing the …

3

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?