Formula to increase buffer on certain weekdays

I have a buffer in Cell E1


I need the formula in Col F & G to select F1 where date is the 7th as well as the second last working day, However if the 7th is a weekend or public holiday, then amend formula where this is the first workday prior to the 7th. If the second last day is a weekend or public holiday, then amend formula where this is the first workday prior to the second last day in the month

i have attached sample data


Your assistance is most appreciated

I have also posted on https://www.myonlinetraininghub.com/...eekdays#p24485

Sorry for not being clear in post # 1



I have a buffer in Cell E1 as well as an increased buffer in Cell F1



I have a formula in Col F in row F10 onwards. where I need to compute how much to transfer to savings, taking into account that the closing balance must not go below the buffer in E1



i need to amend my formula so that E1 changes to F1 on the 6th (if the 6th falls on a weekend or public holiday then the first working day prior to this) as well as one working day before the last day of the month.





it would be appreciated if you could amend my formula taking the above into account