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

    • HansVogelaar's avatar
      HansVogelaar
      MVP
      Mar 30, 2024

      KXSAM 

      Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?

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

        HansVogelaar 

         

        https://1drv.ms/x/s!ApWF8HufqWHqk2vxYCxl3PG4_7fD?e=5BsOBr

        on onedrive.  

Resources