I need to tally the dates from a data table to another data table in two separate excel files. The dates in the two excel files are different. In order to tally the dates, I would need to get the dates in column A, then I would need to minus the numbers of days (working days) according to the table below.
However, when I minus the dates I would need to consider if the days fall within the eve of a weekend or eve of a holiday. If the days fall within a weekend or holiday I need to ignore those days and only minus working days. I have attached another table for reference for the holiday dates.
How may I calculate the dates with working days and holidays in mind?
Thanks in advance!