Array of month days in a row

[jl2509]

Hi all

Can anyone please provide a solution to creating an array of days for a given month as per the table below.

A

B

C

D

E

F

G

H

I

J......

Jan

1

2

3

4

5

6

7

8

thru 31

The array of dates staring in B1 should stop at the number of days per month based on what month (in text) is in A1 i.e. Jan = 31, Feb = 28 (leap year dependent)

Appreciate the help

 

[FormR]

Hi assuming you have a reasonably modern version of Excel then you can try:

Book1
	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
1	Jan	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
Sheet1

Cell Formulas
Range	Formula
B1:AF1	B1	=SEQUENCE(,DAY(EOMONTH("1"&A1,0)))
Dynamic array formulas.

 

[jl2509]

Thanks for the response.

This works fine for what I need.

Much appreciated.

 

[jl2509]

Hi
To take this a step further, if you add 2 rows above the current data, and in Cell A1 add the calendar year "2024", how do you make the day of the week dynamic starting at Cell B2, based on the date now in row 3. Can this also be an array?
i.e.

 

[FormR]

Hi, you could try like this:

Book5
	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
1	2024
2		Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon	Tue	Wed
3	Jan	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
Sheet1

Cell Formulas
Range	Formula
B2:AF2	B2	=TEXT(DATE(A1,MONTH(1&A3),B3#),"ddd")
B3:AF3	B3	=SEQUENCE(,DAY(EOMONTH(A3&A1,0)))
Dynamic array formulas.

 

[jl2509]

Thanks for the reply
I get a very odd result where either formula shows the day as Sun for cell B2?
Even if I use =TEXT(WEEKDAY(B3), "ddd") it shows as Sun?
The 1st Jan 2024 is Mon as your example shows?

 

[jl2509]

Hi

Please ignore my ramblings. I had a typo

Your solution works perfect

Thank you

 

[FormR]

Please ignore my ramblings. I had a typo

I did delete and re-post my suggestion so you may have been looking at the first version I posted that was seriously flawed!