- K2 is user input box for the starting date.

- B2 to H13 get filled, one full calendar week per row, Monday to Sunday.

The user-input date gets put into B2 that has this formula that starts the dates on the immediately-following Monday:

=IF(K2<>"",K2+7-WEEKDAY(K2+7-2),"")

And C2 to H13 get populated with my mundane, extremely pedestrian formula and its variations to increment by one day:

C2: =IF($B$2<>"",SUM($B$2+1),"")

D2: =IF($B$2<>"",SUM($B$2+2),"")

E2: =IF($B$2<>"",SUM($B$2+3),"")

(I know, crude, but I don't know a more elegant way and this does get the job done <g>.)

The challenge is that although I have font set to 6, it's still a bit too wide for my Micro planner and would like to change ddd to my custom short day format of:

M, T, W, Th, F, S, Sn.

The custom format for each cell of B2 to H13 is: ddd.mmm.dd.yyyy [i.e., recent help got me this formula for another part of the same planner, just to give an example: =TEXT(TODAY(),"yyyy-mm-dd")& " ." &CHOOSE(WEEKDAY(TODAY()),"Sn","M","T","W","Th","F","S")].

Please, how could one get the yyyy.mm.dd.ddd for the formulas below, then, to display as 2020-12-21.M, in lieu of 2020-12-21.Mon?:

-----------------------------------------------

=IF(K2<>"",K2+7-WEEKDAY(K2+7-2),"")

-----------------------------------------------

=IF($B$2<>"",SUM($B$2+1),"")

-----------------------------------------------

Thank you!