Automatic entries in cells based on a date range

[StantonSmith]

Looking for help creating a formula that will do the following - 

Column A is start date

Column B is an end date

Column C is a number

The rest of the columns are dates that I want the number in column C to be automatically placed if the date falls in the range of columns A and B.

Thanks,

Stan

[#2 · Accepted solution]

@StantonSmith 

In D2:

=IF(AND(D$1>=$A2,D$1<=$B2),$C2,"")

Fill down and to the right (or vice versa).

See the attached workbook.

[#3]

@StantonSmith 

Using Excel 365, a single formula

=IF((day>=startDate)*(day<=endDate),number,"")

entered into cell D2 will generate the entire 389x352 array.  What use it is, I have no idea.

[#4]

@Hans Vogelaar

Thanks so much! saved me a lot of time

[#5]

thanks! its for showing the amount of people processing over a date range and related to capacities. I know it is "analog" but I like to see the array before summing and making it into a chart.