Return value to a weekday closest to certain date

[Ashleytaylor1702]

Hi,

I’m trying to return salary (from one cell) in to a cell next to the 28th (calendar as list) or Friday prior to the 28th if the 28th falls on weekend or bank holiday. Any help greatly appreciated.

Thanks

 

[Ashleytaylor1702]

Is anyone able to help with this?

Many Thanks