How to calculate days , month and year

AppSheet AppSheet Q&A
1

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?

2

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

3

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

4

This post may help, I am just trying to find how to calculate the days:

[Convert Birthdate to Current Age in Years/Months format](https://community.appsheet.com/t/convert-birthdate-to-current-age-in-years-months-format/16263) 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 …