Uploaded image for project: 'Keikai'
  1. Keikai
  2. KEIKAI-770

A Formula with DATEDIF function calculated to incorrect value

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Normal Normal
    • 6.1.0
    • None
    • Formula
    • None
    • None

      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

       

            DevChu DevChu
            henrichen henrichen
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

              Created:
              Updated:
              Resolved: