populating dates of the current month with a formula

[jbrown021286]

TECH HOURS WORKSHEET 5.0.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Total Tech 3/4's Available	Total Tech 3/4's Flagged	Proficiency %	Total Tech 1/2's Available	Total Tech 1/2's flagged	Proficiency %							Date
2	1-May	7	77.4	138%	12	61.1	64%							5/8/2024
3	2-May	7	72.2	129%	12	61.7	64%
4	3-May	6	43.5	91%	13	62.8	60%
5	4-May	6	47.8	100%	14	79.6	71%
6	6-May	6	41.2	86%	12	58.7	61%
7	7-May	6	52.6	110%	11	66.5	76%
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
Report TEST

Cell Formulas
Range	Formula
B2:B33	B2	=IFERROR(INDEX('Calculated Data'!$C$46:$AG$46,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
C2:C33	C2	=IFERROR(INDEX('Calculated Data'!$C$47:$AG$47,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
D2:D33,G2:G33	D2	=IFERROR(C2/(B2*8),"")
E2:E33	E2	=IFERROR(INDEX('Calculated Data'!$C$44:$AG$44,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
F2:F33	F2	=IFERROR(INDEX('Calculated Data'!$C$45:$AG$45,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
N2	N2	=TODAY()

i am wanting to put a formula in column a that automatically does what i am doing manually in this example i need it to populate all the days of the current month starting with in this example 5/1 and ending the day before the current date. i also need it to not populate Sundays. in N2 i have a cell to reference the current date. is this possible?

 

[Cubist]

Try:

=LET(
start,EOMONTH(N2,-1)+1,
d,start+SEQUENCE(DAY(EOMONTH(start,0)),,0),
FILTER(d,WEEKDAY(d,1)<>1))

 

[Georgiboy]

What I was creating:

=LET(
eom,EOMONTH(N2,-1),
s,SEQUENCE(N2-eom-1,,eom+1,1),
FILTER(s,WEEKDAY(s)>1))

 

[jbrown021286]

What I was creating:

=LET(
eom,EOMONTH(N2,-1),
s,SEQUENCE(N2-eom-1,,eom+1,1),
FILTER(s,WEEKDAY(s)>1))

TECH HOURS WORKSHEET 5.0.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Total Tech 3/4's Available	Total Tech 3/4's Flagged	Proficiency %	Total Tech 1/2's Available	Total Tech 1/2's flagged	Proficiency %							Date
2	#SPILL!													5/8/2024
3	#NUM!
4	#NUM!
5	#NUM!
6	#NUM!
7	#NUM!
8	#NUM!
9	#NUM!
10	#NUM!
11	#NUM!
12	#NUM!
13	#NUM!
14	#NUM!
15	#NUM!
16	#NUM!
17	#NUM!
18	#NUM!
19	#NUM!
20	#NUM!
21	#NUM!
22	#NUM!
23	#NUM!
24	#NUM!
25	#NUM!
26	#NUM!
27	#NUM!
28	#NUM!
29	#NUM!
30	#NUM!
31	#NUM!
32	#NUM!
33	#NUM!
Report TEST

Cell Formulas
Range	Formula
A2:A33	A2	=LET(start,EOMONTH(N2,-1)+1,d,start+SEQUENCE(DAY(EOMONTH(start,0)),,0),FILTER(d,WEEKDAY(d,1)<>1))
B2:B33	B2	=IFERROR(INDEX('Calculated Data'!$C$46:$AG$46,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
C2:C33	C2	=IFERROR(INDEX('Calculated Data'!$C$47:$AG$47,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
D2:D33,G2:G33	D2	=IFERROR(C2/(B2*8),"")
E2:E33	E2	=IFERROR(INDEX('Calculated Data'!$C$44:$AG$44,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
F2:F33	F2	=IFERROR(INDEX('Calculated Data'!$C$45:$AG$45,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
N2	N2	=TODAY()

im not sure if i made an error applying the formula but i am getting a spill error

 

[Georgiboy]

Try clearing the cells in column 'A' from row 3 down

 

[Georgiboy]

Also my formula only needs to be in cell A3, you don't need to drag it down.

 

[jbrown021286]

TECH HOURS WORKSHEET 5.0.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1	Date	Total Tech 3/4's Available	Total Tech 3/4's Flagged	Proficiency %	Total Tech 1/2's Available	Total Tech 1/2's flagged	Proficiency %							Date
2	#SPILL!													5/8/2024
3	#NUM!
4	#NUM!
5	#NUM!
6	#NUM!
7	#NUM!
8	#NUM!
9	#NUM!
10	#NUM!
11	#NUM!
12	#NUM!
13	#NUM!
14	#NUM!
15	#NUM!
16	#NUM!
17	#NUM!
18	#NUM!
19	#NUM!
20	#NUM!
21	#NUM!
22	#NUM!
23	#NUM!
24	#NUM!
25	#NUM!
26	#NUM!
27	#NUM!
28	#NUM!
29	#NUM!
30	#NUM!
31	#NUM!
32	#NUM!
33	#NUM!
Report TEST

Cell Formulas
Range	Formula
A2:A33	A2	=LET(start,EOMONTH(N2,-1)+1,d,start+SEQUENCE(DAY(EOMONTH(start,0)),,0),FILTER(d,WEEKDAY(d,1)<>1))
B2:B33	B2	=IFERROR(INDEX('Calculated Data'!$C$46:$AG$46,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
C2:C33	C2	=IFERROR(INDEX('Calculated Data'!$C$47:$AG$47,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
D2:D33,G2:G33	D2	=IFERROR(C2/(B2*8),"")
E2:E33	E2	=IFERROR(INDEX('Calculated Data'!$C$44:$AG$44,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
F2:F33	F2	=IFERROR(INDEX('Calculated Data'!$C$45:$AG$45,MATCH('Report TEST'!A2,'Calculated Data'!$C$35:$AG$35,0)),"")
N2	N2	=TODAY()

im not sure if i made an error applying the formula but i am getting a spill error

that got it thanks for the help