in AppSheet!not working dated if formula.
Calculate the number of days, months, or years between two dates using Excel functions
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?