I need a formula to copy down date in column A based on values in column B. The date needs to be the last business date. If today is Tuesday and Monday is a holiday then it would show Friday's date. If today is Monday then would show Friday's date. If a weekday and is a Tuesday and Monday is not a Holiday then would show Monday's date.
I have added a file where I have a formula and a tab for Holidays.
Thanks in advance