EXCELL 2021 Mac, DATEDIF

Question

Running excel 2021 on Mac Sonoma,&nbsp;&nbsp;When Subtracting two days I get a number 36550.&nbsp; &nbsp; DATEDIFI understand there may be different date system, but how to change&nbsp;Thanks

hansvogelaar · Answer

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

kxsam · Answer

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

hansvogelaar · Answer

KXSAM&nbsp;
Your original post suggested that you were using DATEDIF.
What are the dates in G6 and G7?

kxsam · Answer

HansVogelaar&nbsp;&nbsp;3/23/242/26/24&nbsp;I have swapped the dates, with no success.&nbsp;

hansvogelaar · Answer

KXSAM&nbsp;
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?

Forum Discussion

EXCELL 2021 Mac, DATEDIF

Share

Resources