Forum Discussion

KXSAM's avatar
KXSAM
Copper Contributor
Mar 30, 2024

EXCELL 2021 Mac, DATEDIF

Running excel 2021 on Mac Sonoma,    When Subtracting two days I get a number 36550.    DATEDIF I understand there may be different date system, but how to change   Thanks
Formulas and Functions
HansVogelaar's avatar
HansVogelaar
MVP
Mar 30, 2024

KXSAM 

What was the exact formula you used, and what did the cells referred to contain?

  • KXSAM's avatar
    KXSAM
    Copper Contributor
    Mar 30, 2024
    =DAYS(G6,G7) G6 and G7 contain dates
    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 30, 2024

      KXSAM 

      Your original post suggested that you were using DATEDIF.

      What are the dates in G6 and G7?

      • KXSAM's avatar
        KXSAM
        Copper Contributor
        Mar 30, 2024

        HansVogelaar 

         

        3/23/24

        2/26/24

         

        I have swapped the dates, with no success. 

Resources