DATEDIF function equivalent

Hi, 

to find the current age of children in  0y0m0d format, datedif function is an easy choice in spreadsheets but appsheet does not have this function. However the formula : 

floor(((hour(today()-[DOB])/24)/365.25))& "y" & floor((MOD((hour(today()-[DOB])/24),365.25)/30.4375)) & "m" & ceiling((MOD((hour(today()-[DOB])/24),365.25)-(floor((MOD((hour(today()-[DOB])/24),365.25)/30.4375))*30.4375)))& "d"

(where DOB is date of birth)

sort of does the work but does have a few days discrepancy with datedif function.

Is there a better way of doing this??

0 0 168
0 REPLIES 0
Top Labels in this Space