Forum Discussion
ChetInSanJose
Sep 22, 2022Copper Contributor
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...
JoeUser2004
Sep 22, 2022Bronze Contributor
The quickest and best way to get a constructive answer is to attach an example Excel file. Click "browse" at the bottom of the reply window, or upload the file to a file-sharing website and post the download URL.
At a minimum, you should show us what is in B3 and what does ISTEXT(B3) return. Typically, a #VALUE error means one of two things: B3 contains a number, not text; or Excel cannot recognize the form of the text as a date, based on the current system configuration.
Note the latter: "current system confirguration". That might have changed, unbeknownst to you, especially if you use Office 365 (based on other users' experience).
ChetInSanJose
Sep 22, 2022Copper Contributor
JoeUser2004 The problem is that these formulas worked for years, but when I opened the file again after a year, the formulae now don't work. I didn't change anything at all in the workbook. It seems to me, therefore, that something has changed in Excel. When I get to my computer I'll send you the info you asked for. Thanks much for trying to help.
Kindest regards,
C. Aeschliman