Setting up and invoice system and i'm trying to make as much of is automatic as possible. I've set it up with a week ending date/formula that auto fills the days of the week Monday thru Sunday.

My goal now is one cell in particular needs to read, "Week of: Date(from cell F6) Thru Date(from cell L6)

Can anybody help with the formula?

Dates are Week Ending (H4) F6 G6 H6 I6 J6 K6 L6 Monday (G6-1) Tuesday (H6-1) Wednesday (I6-1) Thursday (J6-1) Friday (K6-1) Saturday (L6-1) Sunday (=H4)