We are encountering strange issue while updating date column in SharePoint online excel files.
When the dates are entered using dots in between the date and month( like 21.10 , 18.5),in excel it is displaying as 1/21/1900 and 1/18/1900. This applies for any dates entered using dots between DD and MM. Is this a bug?
This issue doesn’t occur if the dates are entered using a – (like 21-10,18-5) or writing down the month alphabetically(like 21-Oct, 18-May).