Excel Date Formula: how to schedule every other workday from a given date?

I need to automatically shift a column of dates based on a starting date. If we start on a Monday the 7thm the next scheduled date would be Wednesday the 9th, followed by Friday the 11th but NOT Sunday the 13th, landing instead on Monday the 14th...





Thanks!|||=IF(WEEKDAY(A1)=6,A1+3,A1+2)





Drag the above formula down your column using the fill handle. Make sure the whole column is formatted as date (right-click on column letter, Format cells, Custom, dddd dd mmm)