Figured it out: VBA
My tab names are Today, TodayPlus1,...TodayPlus4. You won't need most of this code if you want to include Saturday and Sunday. I got rid of them.
'Name Tabs by date
Today.Caption = (Format([TxtBxDate], "dddd mm/dd"))
TodayPlus1.Caption = (IIf(Weekday([TxtBxDate]) = 6, Format(DateAdd("d", 3, [TxtBxDate]), "dddd mm/dd"), Format(DateAdd("d", 1, [TxtBxDate]), "dddd mm/dd")))
TodayPlus2.Caption = (IIf(Weekday([TxtBxDate]) = 6, Format(DateAdd("d", 4, [TxtBxDate]), "dddd mm/dd"), IIf(Weekday([TxtBxDate]) = 5, Format(DateAdd("d", 4, [TxtBxDate]), "dddd mm/dd"), Format(DateAdd("d", 2, [TxtBxDate]), "dddd mm/dd"))))
TodayPlus3.Caption = (IIf(Weekday([TxtBxDate]) = 6, Format(DateAdd("d", 5, [TxtBxDate]), "dddd mm/dd"), IIf(Weekday([TxtBxDate]) = 5, Format(DateAdd("d", 5, [TxtBxDate]), "dddd mm/dd"), IIf(Weekday([TxtBxDate]) = 4, Format(DateAdd("d", 5, [TxtBxDate]), "dddd mm/dd"), Format(DateAdd("d", 3, [TxtBxDate]), "dddd mm/dd")))))
TodayPlus4.Caption = (IIf(Weekday([TxtBxDate]) = 6, Format(DateAdd("d", 6, [TxtBxDate]), "dddd mm/dd"), IIf(Weekday([TxtBxDate]) = 5, Format(DateAdd("d", 6, [TxtBxDate]), "dddd mm/dd"), IIf(Weekday([TxtBxDate]) = 4, Format(DateAdd("d", 6, [TxtBxDate]), "dddd mm/dd"), IIf(Weekday([TxtBxDate]) = 3, Format(DateAdd("d", 6, [TxtBxDate]), "dddd mm/dd"), Format(DateAdd("d", 4, [TxtBxDate]), "dddd mm/dd"))))))
End Sub