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