Forum Discussion
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 see "Volatile".
Equations:
- Column M references another sheet in the workbook: =XLOOKUP(K2, Assets_Path, Assets_Expiration)
- Column N: =IF(I2<TODAY(),"Yes", "No")
- Column O: =IF(M2<TODAY(),"Yes","No")
- Column P: =IF(AND(I2<TODAY(), M2<TODAY()), "Yes", "No")
- Column Q (Used just to see if the TODAY function was working): =TODAY()
I have made sure that the referenced cells in column M, column I, and the result in column M are all date format and I've tried using the NOW() function instead but got the same result. I have also tested the equations on items that are not expired and received the same results as in the screenshot.
I'm sure the solution is right in front of me but I can't figure it out.
Text to Columns shall work if for the column I on the third step of the wizard you select Date and MDY
5 Replies
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
