Forum Discussion
IF TODAY Equation Not Calculating Properly
Text to Columns shall work if for the column I on the third step of the wizard you select Date and MDY
renee_crozier The left alignment of the 'dates' in column M might indicate that they are in fact texts that just look like dates. Can't be sure about the dates in column I, though these seem to be right-aligned.
Enter the following in an empty cell =ISNUMBER(M2). What do you get? I guess FALSE. Use Text-to-columns to transform the entries in column M into real dates.
Thank you for your response. All fields and references are set to date (the green sheets are those that are referenced in the white sheet) and ISNUMBER returned false. Also, Text-to-Columns did not work.
Text to Columns shall work if for the column I on the third step of the wizard you select Date and MDY
- Thank you for the clarification. The Link Expired column is now working as expected. For future reference, why did I need to do that?
I had a thought to look for a function that would convert the result to date format and came across DATEVALUE. I was able to combine that with my XLOOKUP and IF statements to get the equation to work. Somehow it resolved the problem. I really appreciate your help on this one!It all depends in which locale you are. Text to Columns converts texts to dates in your locale in any case. If you are in US locale, DATEVALUE("11/28/2022") works, for other locales not.