Hello everyone, Please I would like a APP Formula to calculate age in Years, months and days
I used this formula but the result is wrong.
IF(
TODAY() >= [Birthday],
(
IFS(
YEAR(TODAY()) - YEAR([Birthday]) = 0, "",
YEAR(TODAY()) - YEAR([Birthday]) = 1, "1 An ",
TRUE, (YEAR(TODAY()) - YEAR([Birthday])) & " Ans "
)
&
IFS(
OR(
MONTH(TODAY()) < MONTH([Birthday]),
AND(
MONTH(TODAY()) = MONTH([Birthday]),
DAY(TODAY()) < DAY([Birthday])
)
),
(12 + MONTH(TODAY()) - MONTH([Birthday])) & " M ",
MONTH(TODAY()) = MONTH([Birthday]),
"",
TRUE, (MONTH(TODAY()) - MONTH([Birthday])) & " M "
)
&
IFS(
DAY(TODAY()) < DAY([Birthday]),
(DAY(EOMONTH(TODAY(), -1)) + DAY(TODAY()) - DAY([Birthday])) & " J",
DAY(TODAY()) = DAY([Birthday]),
"",
TRUE, (DAY(TODAY()) - DAY([Birthday])) & " J"
)
),
""
)
I got this result
36 Ans 11 M 23 J
for this date of birth
June 6, 1988
while the result should be
35 Years 11 M 23 D
Thank you so much
User | Count |
---|---|
19 | |
13 | |
8 | |
3 | |
2 |