Assign range of pay dates to a specific month in Excel

Pay date = 26th of each month (unless 26th falls on weekend, in that case it would be the closest prior weekday).    Example of Pay date periods:   Column 1: Start Date                Column 2: E...