Calculate 28th of month with exception

[lapta301]

Hi
I’m looking for one formula to calculate the day a payment is made.

Let me explain.

I have a date in A1 which could be any day in the month and in A2 onwards I need to show the 28th day of the month following the date in A1 or the previous working day if the 28th is a weekend.

For example using 1st January 19 in A1 the formula would bring up 28th January as that is the next 28th after the 1st and it is a normal workday.

However if the date in A1 was 29th January then the next 28th would be 28th Feb which be ok because that again is a normal workday.

Also if the date in A1 is 28th if the month then the formula should work out the next 28th not the same 28th that is in A1.

Looking at the calendar the next month where the 28th is a weekend is in April.

I hope that this makes sense and as ever any help would be appreciated.

 

[lapta301]

Hi Steve

That works fine and was exactly what I wanted.
I obviously failed to make my request clear.

Again my thanks to you all