Fri last week, 2 weeks ago, 6 months ago, 1 year ago BUT if it falls on holiday???

Hi,

I have set up a spreadsheet that everyday that I open it automatically calculates from todays date what date was last fri, what date was last Monday, what were the fri and Monday dates 2 weeks ago, 6 months ago, and 1 year ago. You can see the formulas I am using in the attached file.

My issue is about the Fridays - if any of these Fridays happens sometime to be date that was a holiday, how can I set it up so if it was on a holiday to show the Thursday date before that Friday?

Thanks for all your help!!!