date to day

[Trevor3007]

E3 =================>	f	sa	su	m	t	w	th	f	sa	su	m	t	w	th	f	sa	su	m	t	w	th	f	sa	su	m	t	w	th	f	sa	su
E4==================>	July
E5 ==================>	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31

Hi & hope you are all well.

I dont think this can be done , due to how the above has ben created ( and cannot be changed)

Is it possible to put the day of the week in e3,d3,f3 so it will corrospond with the date in e5d5,f5 etc ( month will always be in e4 only)


much appreciate your help & good luck.

 

[johnny51981]

You will need to make sure to include the Year in the situation as well, but here is how I have been able to achieve this (with E6 being the Year)

=TEXT(WEEKDAY(TEXT(DATE(E$6,MONTH($E$4&1),E$5),"MM/DD/YYYY"),1),"Ddd")

 

[Dave Patton]

You can consider the following. The dates are Custom formatted ddd

T202206a.xlsm
	A	B	C	D	E	F	G	H	I	J
1				July
2				2022
3					1	2	3	4	5	6
4					Fri	Sat	Sun	Mon	Tue	Wed
5
7b

Cell Formulas
Range	Formula
E4	E4	=DATE(D2,MONTH(1&D1),E3)
F4:J4	F4	=E4+1

 

[Tetra201]

@ Trevor3007: See if the following formula works for you in cell E3

=INDEX({"su","m","t","w","th","f","sa"},WEEKDAY(E$5&$E$4))

 

[Trevor3007]

@ Trevor3007: See if the following formula works for you in cell E3

=INDEX({"su","m","t","w","th","f","sa"},WEEKDAY(E$5&$E$4))

hi,
thanks for your sugg.

i had to tweak

=INDEX({"su","m","t","w","th","f","sa"},WEEKDAY(E$3&E4))

as (my FAULT) THE DAY SHOULD BE IN E.2 ,F2, F2, ETC

but it put wrong day in ( as july 1st is a friday not a sunday)

thanks any hoo

 

[Trevor3007]

You can consider the following. The dates are Custom formatted ddd

T202206a.xlsm
	A	B	C	D	E	F	G	H	I	J
1				July
2				2022
3					1	2	3	4	5	6
4					Fri	Sat	Sun	Mon	Tue	Wed
5
7b

Cell Formulas
Range	Formula
E4	E4	=DATE(D2,MONTH(1&D1),E3)
F4:J4	F4	=E4+1

 

[Trevor3007]

ROTA BUILD 2022-2023 V3 BH.xlsm
	AM
24
July 2022

ROTA BUILD 2022-2023 V3 BH.xlsm
	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1	2022
2		Fri	Mon	Wed	Sat	Mon	Thu	Sat	Tue	Fri	Sun	Wed	Fri	##	##	##	###	##	##	##	##	##	##	##	##	##	##	##	##	##	##	##
3		July
4	FSE	1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30	31
7	Adrian Sovari	W	W	OFF	R	W	W	W	W	OFF	OFF	E	E	E	E	E	E	E	W	R	W	W	W	OFF	OFF	W	W	W	W	W	W	W
July 2022

Cell Formulas
Range	Formula
E2	E2	=TEXT(WEEKDAY(TEXT(DATE(D$1,MONTH($E$3&1),E$4),"MM/DD/YYYY"),1),"Ddd")
F2	F2	=TEXT(WEEKDAY(TEXT(DATE(D$1,MONTH($E$3&1),F$4),"MM/DD/YYYY"),1),"Ddd")
G2:AI2	G2	=TEXT(WEEKDAY(TEXT(DATE(F$1,MONTH($E$3&1),G4),"MM/DD/YYYY"),1),"Ddd")

as you can see, day dont work...thansk for your help BTW

i also had to tweak to:-

=TEXT(WEEKDAY(TEXT(DATE(D$1,MONTH($E$3&1),F$4),"MM/DD/YYYY"),1),"Ddd")