Test date is a public holiday

EDITED: Ignore this, ​@Alexey_Gusev ‘s solution below is much better

Hmm, I think you’re going to need to link all of your public holiday records to each of the records in APPRO, and then use a formula field to check whether it’s the same date.  I’ve set it up here for you to check out

IF(
  FIND(
    {Date formatted},
    {Date formatted (from Public Holidays)} & ''
  ),
  'True',
  'False'
)

ok thank you very much

Note that a bit easier way is to make Date formatted a primary field in “Holidays” and then in APPRO just clean linked field, copy-paste ‘Data Formatted” in it and that’s all - records with links are holidays.

Oooh yeah, you’re right, that’s a lot cleaner and I’ve set it up here

Hello, I did this in the end, thank you