How to calculate days , month and year

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?

There is no built-in way to do this, so you’ll have to figure how how to do it yourself.

1 Like

Hi Steve Coile,

in AppSheet!not working dated if formula.

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

EXAMPLE in EXCEL :
=DATEDIF(JOIN DATE, EXPIRY SERVICE, “Y”)& " YEARS "
=DATEDIF(JOIN DATE, EXPIRY SERVICE, “YM”)& " MONTHS "
=DATEDIF(JOIN DATE, EXPIRY SERVICE, “MD”)& " DAYS "

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

In Appsheet working in this expression is working year and month :point_down:

Formula
FLOOR(HOUR(TODAY()-[JOIN DATE])/365/24)&" YR "& FLOOR(MOD((HOUR(TODAY()-[JOIN DATE])/24),365)*12/365) & " MO"

How to Calculate Days?
like :
“0” YEARS “0” MONTHS “0” DAYS