Day Count Schedule Charting Excluding Weekend

[causej]

On a formatted schedule with weekdays as column heads, I need to be able to change any one day's date on the schedule (which automatically changes the subsequent dates) and onl have weekdays appear.
this is my IF argument that would not recognize the day name as the argument,=IF(L4="Fri",L4+3,L4+1). The result should be Monday.

 

[VoG]

Try

=IF(TEXT(L4,"ddd")="Fri",L4+3,L4+1)

 

[causej]

Great! Works!