Populate dates for current month

Hello
all

If i write 6 or June or in a cell let's say A2, can I have column B populate a list of dates for the current month (june)? is ther a formula for this?

Thank you

Try this:

=TRANSPOSE(SEQUENCE(1,DAY(EOMONTH(A1,0)),EOMONTH(A1,-1)+1))

AliGW on MS365 Beta Channel (Windows 11) 64 bit

	A	B
1	06/06/2022
2
3		01/06/2022
4		02/06/2022
5		03/06/2022
6		04/06/2022
7		05/06/2022
8		06/06/2022
9		07/06/2022
10		08/06/2022
11		09/06/2022
12		10/06/2022
13		11/06/2022
14		12/06/2022
15		13/06/2022
16		14/06/2022
17		15/06/2022
18		16/06/2022
19		17/06/2022
20		18/06/2022
21		19/06/2022
22		20/06/2022
23		21/06/2022
24		22/06/2022
25		23/06/2022
26		24/06/2022
27		25/06/2022
28		26/06/2022
29		27/06/2022
30		28/06/2022
31		29/06/2022
32		30/06/2022

Sheet: Sheet1

Any use for you???

great thank's so much Ali!