Hello,
I'm trying to compare the date in the white column against the dates in the 3 blue columns (below). If there is a date listed in at least 1 of the 3 blue columns, and one of those date is less than or equal to the date in the white column, then it will return a "Yes". If not, it returns "No".
The dates listed in the white column never change and there will always be a date listed, whereas the blue columns may or may not have a date listed.
I was able to create an IF(OR formula that worked well if a date was listed in the blue columns, but it returns an #INVALIDOPERATION error if there's anything other than dates listed in the blue columns (the "not reported" text above).
Here's the original formula I created:
=IF(OR([CMS Power Derate Date]@row >= [Warranty End Date + 2 Years]@row, [CMS Thrust Derate]@row >= [Warranty End Date + 2 Years]@row, ISDATE([CMS Shutdown Date]@row >= [Warranty End Date + 2 Years]@row)), "Yes", "No")
I then tried to update the formula so it would only compare dates if there is a date listed in the blue columns, but I still get the same error. Here's the updated formula:
=IF(OR(ISDATE([CMS Power Derate Date]@row >= [Warranty End Date + 2 Years]@row), ISDATE([CMS Thrust Derate]@row >= [Warranty End Date + 2 Years]@row), ISDATE([CMS Shutdown Date]@row >= [Warranty End Date + 2 Years]@row)), "Yes", "No")
Any ideas would be greatly appreciated. Thanks!
