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.
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
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
This post may help, I am just trying to find how to calculate the days:
User | Count |
---|---|
42 | |
34 | |
27 | |
23 | |
16 |