find missing date on every group date list based on range and criteria

sample no dates.xls

Hi,

Attached sample data.

From date list on every group of columns
How do I find the dates that are not on the date list for every group of column
Based on the date range from "A1" to "A2"
But with a criteria that the "dates that are found not on the date list for every column will be ignored if it is on the date list starting on "A4"
And will also be ignored if it falls on a "Sunday"
The dates found will be shown a row below after every date list column

Actual data has several group of columns separated by a single blank column

hi watersev, thanks for the reply

tried it pressed Run button also tried run code "test"

attached the results, it only retrieves some of the dates and it includes dates outside of the range

please check attachment, this would work correctly with different regional settings

thank you! works great!