Steps to Reproduce
Visit KEIKEI demo page (Excel Like)
in Cell H3: type in `2024/01/31`
in Cell H6: type in `2024/04/01`
in Cell H7: type in `2024/08/31`
In Cell H11: type in following formula
`=IF(IFERROR(DATEDIF(H6,H3,"m"),-1)+1>DATEDIF(H6,H7,"m")+1,0,IFERROR(DATEDIF(H6,H3,"m"),-1)+1)`
Current Result
H11 evaluated to -2
But in Excel, it should evaluated to 0 (zero)
Expected Result
In Excel, it should evaluated to 0 (zero)
Debug Information
Workaround
- relates to
-
KEIKAI-439 support DATEDIF excel function
- Closed