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.

​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.   Read More

​