CLMT is also a fairly new equity with QP price data starting in January 2006. Yet the Excel dividend payment date function indicates that a payment occurred in 1999. This seems to be a common problem. It creates problems in developing logic to pick out the most recent date and its associated payment. In my previous example , as I recall, the erroneous 1999 dates appear where you would expect the most recent dates to be.
