I have a 7-column single row worksheet.

Cell A1 contains the forumla "=TODAY()".

I have two issues:

(a) I want to format A1 as simply the first letter of the name of the day, e.g.:
sunday is S
saturday is S
monday is M, and so on

...currently I have it formatted Custom, type "ddd" and it gives me Sun, Sat, Mon, etc., not sure what to tweak to get what I want.

(b) I want the remaining 6 columns to be oututs, in order, based on the day that fills A1, e.g.:
if A1 = a sunday, then A1:G1 should read, S | M | T | W | T | F | S
if A1 = a monday, then A1:G1 should read, M | T | W | T | F | S | S

Any help with these would be appreciated.

- Jim