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??
User | Count |
---|---|
21 | |
15 | |
4 | |
3 | |
3 |