Drop down list to create a series of dates for a daily checker.

[Paramed217]

Hello,

Drop down list to create a series of dates for a daily checker. As stated I am trying to create a drop down list in excel in cell A1 that contains a list of the months. Once a month is picked I want to populate the dates for that month across the a range. 1/1/22 - 1/31/22 and on. The dates only need to be in numerical order we don't care day designations ie: Sun, Mon, Tues.... Whats everyone's thoughts or tools that would be able to make this function.

Regards

 

[Peter_SSs]

Like this?

22 08 27.xlsm
	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	August	8/1/22	8/2/22	8/3/22	8/4/22	8/5/22	8/6/22	8/7/22	8/8/22	8/9/22	8/10/22	8/11/22	8/12/22	8/13/22	8/14/22	8/15/22	8/16/22	8/17/22	8/18/22	8/19/22	8/20/22	8/21/22	8/22/22	8/23/22	8/24/22	8/25/22	8/26/22	8/27/22	8/28/22	8/29/22	8/30/22	8/31/22
Dates

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

 

[Paramed217]

Like this?

22 08 27.xlsm
	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	August	8/1/22	8/2/22	8/3/22	8/4/22	8/5/22	8/6/22	8/7/22	8/8/22	8/9/22	8/10/22	8/11/22	8/12/22	8/13/22	8/14/22	8/15/22	8/16/22	8/17/22	8/18/22	8/19/22	8/20/22	8/21/22	8/22/22	8/23/22	8/24/22	8/25/22	8/26/22	8/27/22	8/28/22	8/29/22	8/30/22	8/31/22
Dates

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

Just like that!

 

[Paramed217]

However when I do it all I get is an error code Function SEQUENCE parameter 1 value is 0. It should be greater than or equal to 1. is there something I am missing?

 

[Peter_SSs]

As you can see above it works for me as is. What happens if you use this instead?

=SEQUENCE(1,DAY(EOMONTH(1&A1,0)),DATEVALUE(1&A1))

when I do it all

What do you mean by "do it all"?

 

[Paramed217]

As you can see above it works for me as is. What happens if you use this instead?

=SEQUENCE(1,DAY(EOMONTH(1&A1,0)),DATEVALUE(1&A1))

What do you mean by "do it all"?

When I add it to my excel sheet it drop an error code in reference to the drop down menu. With the new formula populates it sends an error will overwrite a cell.

 

[Paramed217]

Disregard. I was using the formula in all the cells. Appreciate the help!!

 

[Peter_SSs]

Glad you got it sorted. Thanks for letting us know.