Auto Populate cells between 2 dates

[Steves73]

Hi All

Trying to find a formula that places the value in Cell C2 on row 4 between the start date in A1 and End Date in B1

As you will see below, need a 2 (Or What ever the value is in C2) below the 01//02/25 and 08/02/25

Assume it would be an if statement, just can't get my head around it

Regards

 

[Fluff]

How about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N
1
2	01/02/2025	08/02/2025	2
3
4		28/01/2025	29/01/2025	30/01/2025	31/01/2025	01/02/2025	02/02/2025	03/02/2025	04/02/2025	05/02/2025	06/02/2025	07/02/2025	08/02/2025	09/02/2025
5						2	2	2	2	2	2	2	2
Sheet6

Cell Formulas
Range	Formula
B5:N5	B5	=IF((B4:N4>=A2)*(B4:N4<=B2),C2,"")
Dynamic array formulas.