I have the same problem and I think there is no way to find out with VBA. Apparently Occurences and PatternEndDate return matching values for the same end. So I decided to primarily use the PatternEndDate.