When in Excel we use the DATAM formula to calculate months, we have the month changed while keeping the day.
Example: 03/11/2023 in cell A1
(dd/mm/yy)
If we do the command =DATAM(A1;1) in cell B1, we will have the result 02/12/2023.
But if you do the same test in Excel, it will return the result 03/12/2023
I would really like to correct this, as I recently migrated from Windows and MS suite and I need this correct data in an important spreadsheet.