Oct 20 2021 12:51 PM
Oct 23 2021 04:38 AM
It depends on regional format setting in your Google Sheets environment and for environment where you use Excel.
Oct 23 2021 08:46 AM
Oct 23 2021 09:32 AM
If an American sends you a message with date 3/4/2012 as text, there is no way of knowing whether he is using the US system (March 4) or has converted it for the recipient (3 April); though unjustified stereotyping might suggest the former. If the date is an Excel serial number, the conversion between systems takes place automatically.