Formula for Friday 14 days from start date, but closest to 15th or 30th

I have a formula that will take a start date, add 14 days and find the closest Friday to that new date.

Please Login or Register  to view this content.

Is there any way to make a formula that will take P1, add 14 days and then find the closest Friday to the 15th or 30th of the month (whichever is the smaller difference). Also if P1 + 14 days is the 15th or 30th then that should be the date.

Side note, for February I suppose it would have to be the 28th or 29th.

Thanks