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

support DATEDIF excel function

    XMLWordPrintable

Details

    • New Feature
    • Resolution: Fixed
    • Normal
    • 5.8.0
    • None
    • Formula
    • Security Level: Jimmy

    Description

      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))

      Attachments

        Activity

          People

            jumperchen jumperchen
            cor3000 cor3000
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: