Details
https://support.microsoft.com/en-us/office/datedif-function-25dba1a4-2812-480b-84dd-8b32a451b35c
Workaround
e.g. alternative way to calculate the age of a person from the DOB stored in A1 using YEARFRAC
=DATEDIF(A1, TODAY(), "Y"))
=TRUNC(YEARFRAC(A1, TODAY(), 1))
- relates to
-
KEIKAI-770 A Formula with DATEDIF function calculated to incorrect value
-
- Closed
-