Forum Discussion
DateValue function
Years ago, I set up a spreadsheet to monitor and graph my blood pressure, using the DATEVALUE function to convert text dates to numerical dates. When trying to update the table today, I discovered th...
Adding to Joe's comment regarding "system configuration," you might see if the systems short date format setting has changed (in windows control panel). If the system's short date format is mm/dd/yyyy and you have a date like 24/09/2022, then you would get a value error because what it thinks is the month is >12.