Auto fill dates and days of the week from month

[drefiek2]

Hi,
I have a month in cell B8 and then 31 adjacent cells (C8:AG8) that I want to auto populate the numbered days, based on the month that is in cell B8. If a month has fewer than 31 days then it should leave the cells blank.
In the row below (C9:AG9) I want each cell to auto populate the day of the week (just the first two letters), based on the date from C8:AG8.
Thanks in advance.

 

[awoohaw]

try this, it does require a Date value in cell B8:

Book2
	A	B	C	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
8		April	01	02	03	04	05	06	07	08	09	10	11	12	13	14	15	16	17	18	19	20	21	22	23	24	25	26	27	28	29	30
9			Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu	We	Th	Fr	Sa	Su	Mo	Tu
Sheet1

Cell Formulas
Range	Formula
C8:AF8	C8	=B8+SEQUENCE(1,DAY(EOMONTH(B8,0)),0,1)
C9:AF9	C9	=LEFT(TEXT(C8#,"dddd"),2)
Dynamic array formulas.

 

[drefiek2]

try this, it does require a Date value in cell B8:

It works thanks very much!

 

[awoohaw]

My pleasure, thanks for the feedback.
Best wishes!