Forum Discussion
Solved
IF TODAY Equation Not Calculating Properly
I am trying to mark whether the asset or link has expired and return yes or no but they are not calculating properly. When I try to go into the formula editor to see where the error could be, I just ...
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 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.