Forum Discussion
KXSAM
Mar 30, 2024Copper Contributor
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
HansVogelaar
Mar 30, 2024MVP
What was the exact formula you used, and what did the cells referred to contain?
KXSAM
Mar 30, 2024Copper Contributor
=DAYS(G6,G7) G6 and G7 contain dates
- HansVogelaarMar 30, 2024MVP
- KXSAMMar 30, 2024Copper Contributor
- HansVogelaarMar 30, 2024MVP
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?