EXCELL 2021 Mac, DATEDIF

[KXSAM]

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

[#2]

@KXSAM 

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

[#3]

=DAYS(G6,G7) G6 and G7 contain dates

[#4]

@KXSAM 

Your original post suggested that you were using DATEDIF.

What are the dates in G6 and G7?

[#5]

@Hans Vogelaar 

3/23/24

2/26/24

I have swapped the dates, with no success. 

[#6]

@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?

[#7]

@Hans Vogelaar 

main.xlsm

on onedrive.  

[#8]

@KXSAM 

Thanks! Select G6 and look at the formula bar. Or format G6 to display the four-digit year.

You'll see that the date in G6 is in 2124 instead of in 2024. Once you correct that, the DAYS formula should return a "normal" result.

And the formula in G9 should be =G7-G6.

[#9]

Thanks a lot, simple mistake and gray hair