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 |
---|---|
41 | |
29 | |
22 | |
20 | |
15 |