Good night friends:
My main idea is to compare each of the dates in sheet 1 with each of the dates in book two.
If the date for book 1 is on sheet 2, subtract one day. “This new date” would repeat the loop to verify that the new date is not in sheet 2, if it is found, continue subtracting.
The problem I have is that I cannot subtract days from the date without affecting the entire flow
PS: Sheet two is a calendar with Saturdays, Sundays and holidays.
HLDates.zip (34.2 KB)