7 days of the week

J

James C

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 th
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 m
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 th
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.

- Ji
 
C

Cutter

One way:

In A1 type: =CHOOSE(WEEKDAY(TODAY()),"S","M","T","W","T","F","S")

In B1 type
=CHOOSE(IF(WEEKDAY(TODAY()+1)=8,1,WEEKDAY(TODAY()+1)),"S","M","T","W","T","F","S")

In C1 type
=CHOOSE(IF(WEEKDAY(TODAY()+2)=8,1,WEEKDAY(TODAY()+2)),"S","M","T","W","T","F","S")

etc. (changing only the number added to TODAY() in both instances i
each formul
 
R

Ron Rosenfeld

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
Click to expand...

You cannot do what you want to do with formatting.

Here's one solution:

A1: =LEFT(TEXT(TODAY()+COLUMN()-1,"ddd"),1)

Then copy/drag across to G1


--ron
 
T

tjtjjtjt

This is working for me
=VLOOKUP(WEEKDAY(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY()+COLUMN(A1)-1))),{1,"S";2,"M";3,"T";4,"W";5,"T";6,"F";7,"S"},2,0)

Format the cells as General.
Make sure that the formula is all on one line, if you paste it from this
post into your spreadsheet.
 
M

Myrna Larson

You can avoid the VLOOKUP formula with the MID function:

=MID("SMTWTFS",WEEKDAY(TODAY()+COLUMN()-1),1)
 
Top