Forum Discussion
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
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?
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.
- Thanks a lot, simple mistake and gray hair
