Leaving this up here for future reference: the problem is that Crystal was pulling the blank value for actions that didn't fit the formula criteria. So by sticking an "else date(9999,12,31)" in there, it pulled the actual minimum. That should hold us for the next 7987 years.
director of development services
philadelphia museum of art